Mike,
Have you tried creating a new table with a field for some sort of date?
Try adding some data and see if the new date time format you specified in
the my.cnf file. See if that works.
-sam
Hello,
Nevermind - duh -datetime is not timestamp (oneday I fullfill my promise
to myself and not
Hello,
approx. how long does it take your big query to run as it is now? Are
these queries appending a table? or are they buiding a result (from a
chain of queries)? Have you tried separating them out? Any difference?
-sam
Hi,
I have a big query that involves searching in more tables, and
Hello therei have seen this question before, I cannot exactly remember
when but it was a while ago. My advice is to go to the mysql.com website
and do a search thru the mailing list using a search term something like
must execute query twice or something to that effect.
-sam
Filesystem