fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
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
fenway replied to TecTao's topic in MySQL Help
Or you could use a proper full-text indexing product, like sphinx. -
Who is this "anybody" who has complete access to your database that you're trying to control?
-
Of course, you should really be storing dates as DATEs.
-
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.
-
Ahoy-hoy.
-
ENUM is the way to go, if you insist of such column types.
-
I believe there's an XML export option.
-
You want a proper fulltext index -- MySQL isn't really good at that -- check out Sphinx.
-
Also, you've just double-posted.
-
Sure -- post the EXPLAIN results of each part of the UNION separately.
-
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.
-
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.
-
Add * first, then add aliases.
-
Echo the actual string.
-
Are you trying to audit their activity? Or show this to the user? How many updates do you expect?
-
Sounds like you have STRICT mode enabled.
-
Don't use approximate data types with an exact one will do.
-
Problem Updating A Decimal(20,5) Field In Mysql Via Php
fenway replied to jaxdevil's topic in MySQL Help
Echo the query. -
What makes you think they're not distinct -- did you check for trailing spaces / whitespace?
-
That would be a JOIN USING (post_id).
-
MySQL does offer an embedded server, and InnoDB has a ready-only option for CD-ROMs and such.
-
You can turn on the slow query log.
-
http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html#option_mysql_default-character-set
-
Yeah, that would make no sense based on set theory -- I'm curious as to why you'd actually want to do this.