| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jeremy Zawodny | Date: | May 3 2004 6:02pm |
| Subject: | Re: urban myth? | ||
| View as plain text | |||
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! <Jeremy@stripped> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/
| Thread | ||
|---|---|---|
| • Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Martijn Tonies | 22 Apr |
| • Re: Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Adam | 28 Apr |
| • urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: urban myth? | Daniel Clark | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Bob Ramsey | 3 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Michael Stassen | 3 May |
| • RE: urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Anders Karlsson | 3 May |
| • Re: urban myth? | Michael T. Babcock | 13 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Jeremy Zawodny | 3 May |
| • Re: urban myth? | gerald_clark | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: Create table results in (errno: 121) | beacker | 22 Apr |
| • RE: urban myth? | Mike Johnson | 3 May |
| • Re: urban myth? | Udikarni | 3 May |