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
