List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 9 1999 5:53pm
Subject:Re: SELECT output does not keep ID order ?
View as plain text  
At 15:24, 19990808, Christos J. Pontikis wrote:

Doh!  Sorry, sent out an incomplete post.  The other poster said
that MySQL was doing "what's supposed to happen".  This is only
true in a loose sense - what is supposed to happen, as far as what
order the rows come out in, is totally unspecified.  MySQL can
give you the rows in any order it pleases.  It could, if it wanted,
give you the rows in a different order for the exact same query
done one right after the other.  There's really nothing that is
"supposed" to happen.

Tim
Thread
SELECT output does not keep ID order ?Christos J. Pontikis8 Aug
  • Re: SELECT output does not keep ID order ?Graham Ashton8 Aug
  • Re: SELECT output does not keep ID order ?Thimble Smith9 Aug
  • Re: SELECT output does not keep ID order ?Thimble Smith9 Aug
Re: SELECT output does not keep ID order ?Christos J. Pontikis10 Aug