On Mon, May 03, 2004 at 12:39:48PM -0500, Boyd E. Hemphill wrote: > > 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?
In reality, the order is often the same but you should never DEPEND on that being the case without an ORDER BY clause. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
