Hi Stephan,
Let's see the case :
I use ORDER BY, because I want that order in PTemp
table, so I do not have to order them later (because
they are retrieved several times later).
1. Inserting with mysql c.l.i. :
I get the records well sorted : first by a, secondly
by b and finally by c (ascendig
Hallo everyone !
I already sent this, but I think some people think is
not clear enough ;-)
Im using Mysql 4.0.12 on RedHat 7.3 x86
I know it's not the last binary but I cannot upgrade
now. (And i saw nothing about this in the changelog
for 4.013 and 4.0.14)
I found the following :
I have two
f almost 1 second
between the first select
and the update, because the column `b' takes the
current time!.
Only happens with timestamp columns not with datetime
ones.
I hope it will help you to make MySQL better.
For further information, please don't hesitate to
contact me at:
[EMAI
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
