[Merge Multiple Queries]

I suppose you *could* try to JOIN them all -- seems too scary to bother.

[Is There A Way To Search An Entire Table For Wildcard Word Or Phrase]

Or you could use a proper full-text indexing product, like sphinx.

[Not Allowing Certain Tables While Backup]

Who is this "anybody" who has complete access to your database that you're trying to control?

[Select Data From A Different Table]

Of course, you should really be storing dates as DATEs.

[Please Help With Sql Table Layout]

If the changes are minimal, you can just query the underlying tables directly, based on timestamp.

 

This is assuming the admin will be reviewing this kind of this daily -- i.e. you prepare the list to review 'often'.

 

I suppose you could log ( table, uid, user, timestamp ) too.

[New Admin: Pikachu2000]

Ahoy-hoy.

[Problems With Tables]

ENUM is the way to go, if you insist of such column types.

[Mysqldump Table Issue]

I believe there's an XML export option.

[Sitewide Search - Requiring Multiple Tables]

You want a proper fulltext index -- MySQL isn't really good at that -- check out Sphinx.

[Unable To Perform Union, Getting #1248 - Every Derived Table Must Have Its Own Alias Error]

Also, you've just double-posted.

[Ant Suggestions For Improving This Query?]

Sure -- post the EXPLAIN results of each part of the UNION separately.

[Normal Query Syntax Not Working, '' For Numeric]

It is quite common to do this, and not wrong at all. If the application is building queries and doesn't know the column types, this is how to do it.

 

This is *not* how to do it -- don't pretend that it is.

 

It doesn't work "as expected" -- it works by accident.

 

It's trivial to have your DB wrapper consult your schema once.

[Normal Query Syntax Not Working, '' For Numeric]

Look for sql_mode in the my.cnf file.

 

Of course, you shouldn't disable it -- why not enter 0, or NULL? A string isn't a valid number.

[Sql Help]

Add * first, then add aliases.

[Can't Insert String To Mysql]

Echo the actual string.

[Please Help With Sql Table Layout]

Are you trying to audit their activity? Or show this to the user? How many updates do you expect?

[Normal Query Syntax Not Working, '' For Numeric]

Sounds like you have STRICT mode enabled.

[Mysql Type For Integers With Decimals]

Don't use approximate data types with an exact one will do.

[Problem Updating A Decimal(20,5) Field In Mysql Via Php]

Echo the query.

[Union Statement Not Working In Mysql]

What makes you think they're not distinct -- did you check for trailing spaces / whitespace?

[Do I Need To Make A Join, Or Use A Statement?]

That would be a JOIN USING (post_id).

[Product Catalogue From Sql Database]

MySQL does offer an embedded server, and InnoDB has a ready-only option for CD-ROMs and such.

[Find Where Queries Originate]

You can turn on the slow query log.

[Mysql Php Import Script]

http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html#option_mysql_default-character-set

[In And How It Handles Duplicates]

Yeah, that would make no sense based on set theory -- I'm curious as to why you'd actually want to do this.