Re: urban myth?

[Peter J Milanese]

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" <bhemphill@stripped>
05/03/2004 01:39 PM
 
        To:     <mysql@stripped>
        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
bhemphill@stripped
Triand, Inc.
www.triand.com
O:  [phone]
M:  [phone]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1