You should never assume that an SQL query will return data in any specific order *unless* you use an ORDER BY to force the sequence of rows in the result set.
Data returned by a query will sometimes appear to come out in a particular order but you should always view this as a lucky coincidence, not something that is guaranteed to happen. Rhino ----- Original Message ----- From: "Marco Neves" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, May 10, 2005 7:14 AM Subject: Re: SELECT Row Numbers? > oix ppl, > > now I have a question. > > I thougth that when you make a SELECT without an ORDER BY, the rows were > returned in natural order, that would be some specific order (insertion > order, presence in file, I don't know, but the order would be always the > same). > > Is this uncorrect? > > Is the returning order variable? > > Thanks, > > mpneves > > On Tuesday 10 May 2005 10:37, Harald Fuchs wrote: > > In article <[EMAIL PROTECTED]>, > > > > [EMAIL PROTECTED] writes: > > > hi, > > > your need is: > > > select * from temp LIMIT 3,4; > > > -- 3 because you have to take the fourth and 4 because dist=3+1 > > > > This does not make sense. A SELECT without an ORDER BY returns the > > rows in some undefined order. If you use "LIMIT 3,4" without ORDER BY, you > > get four rows out of an unordered set, so it's virtually identical to > > "LIMIT 4". As long as the original poster doesn't say what ordering > > he wants, there's no way to tell him a solution. > > -- > Marco Paulo Neves > MySQL Core Certified > Linux Certified Professional > http://themage.bliker.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 06/05/2005 > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]