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 <1115681350.427ff24647102@stripped>,
>
> mfatene@stripped 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
