List:General Discussion« Previous MessageNext Message »
From:Daniel Clark Date:May 3 2004 5:49pm
Subject:Re: urban myth?
View as plain text  
Yes it is a myth.

The records will come back in the same order IF there have been not
inserts and deletes.  Depends on the database product to.

> 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:  (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/mysql?unsub=1
>
>
Thread
• Create table results in (errno: 121)Tom Brown22 Apr
  • Re: Create table results in (errno: 121)Martijn Tonies22 Apr
  • Re: Create table results in (errno: 121)Tom Brown22 Apr
  • Re: Create table results in (errno: 121)Adam28 Apr
    • urban myth?Boyd E. Hemphill3 May
      • Re: urban myth?Peter J Milanese3 May
      • Re: urban myth?Daniel Clark3 May
      • Re: urban myth?Garth Webb3 May
        • Re: urban myth?Bob Ramsey3 May
          • Re: urban myth?Josh Trutwin3 May
          • Re: urban myth?Garth Webb3 May
          • Re: urban myth?Michael Stassen3 May
            • RE: urban myth?Boyd E. Hemphill3 May
              • Re: urban myth?Anders Karlsson3 May
              • Re: urban myth?Michael T. Babcock13 May
      • Re: urban myth?Josh Trutwin3 May
      • Re: urban myth?Jeremy Zawodny3 May
      • Re: urban myth?gerald_clark3 May
        • Re: urban myth?Peter J Milanese3 May
• Re: Create table results in (errno: 121)beacker22 Apr
• RE: urban myth?Mike Johnson3 May
• Re: urban myth?Udikarni3 May