List:General Discussion« Previous MessageNext Message »
From:Peter J Milanese Date:May 3 2004 5:40pm
Subject:Re: urban myth?
View as plain text  
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:  (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