List:General Discussion« Previous MessageNext Message »
From:Josh Trutwin Date:May 3 2004 6:33pm
Subject:Re: urban myth?
View as plain text  
On Mon, 03 May 2004 13:21:56 -0500
Bob Ramsey <robert-ramsey@stripped> wrote:

> Ah, but the ordering is not random.  As your example has it, the
> results are in the order that the entries were inserted into the
> table.  There is an explanation for the order of the returned data.

Conceptually, row order truely is random and meaningless in an RDBMS.  In a multi-user
system who cares who originally inserted the data and in what order?  Just because it
behaves that way now, in future versions of MySQL the developers may decide to do
something completely different and change the default way rows are pulled without an
ORDER BY and they certainly have that right.

Josh
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