Hi, Have you forgotten what's a primary key ? Using order by will sort data, and if it's already sorted, it will be sorted again. Time, memory and maybe disk io.
Using the marco example, i gaved a solution considering iy's what he wants. Till now i don't know if it's ok or not. if so, just add : select * from temp order by Id LIMIT 3,4; if no, the primary key index will give you the order. Mathias Selon Rhino <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
