Does the database not return it in the order that the entries are
submitted?
I've done some log parsing/caching in databases, and the order had always
been the same whether
I use an order by date or not. One thing logs to the db, the other grabs.
Had no problem without an
order.
P
"Boyd E. Hemphill" <[EMAIL PROTECTED]>
05/03/2004 01:39 PM
To: <[EMAIL PROTECTED]>
cc:
Subject: urban myth?
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL statement.
Who is right? Is this behavior specified by ANSI or ISO?
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
