Richard,
> Thanks. Interestingly enough, pulling records without a sort was
rather
> random (rather, influence by the last sort) - but once I placed a
primary
> key on the table, the order of unsorted records is always constant,
even
> after a sort (based on numerous tests yesterday and today wi
Hi Richard,
On Wed, 2002-03-06 at 13:02, Richard S. Huntrods wrote:
> Interestingly enough, pulling records without a sort was rather
> random (rather, influence by the last sort) - but once I placed a primary
> key on the table, the order of unsorted records is always constant, even
> after a so
DLN,
Thanks. Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort (based on numerous tests yesterday and today with the table
Hi.
On Tue, Mar 05, 2002 at 12:10:47PM -0700, [EMAIL PROTECTED] wrote:
[...]
> > Of course, MySQL has some kind of internal order depending on many
> > factors, but you may not rely on it. And neither you may rely on the
> > fact that a PRIMARY KEY influences the internal order. You have to use
>
Richard,
> > I guess your "problem" comes from the fact that SQL has no concept
of
> > internal order. If you do not specify an ORDER BY clause, the order
or
> > records returned is undefined, i.e. random.
>
> That's what I was figuring. I asked because I wanted it confirmed.
Thank
> you.
>
> >
Benjamin,
Benjamin Pflugmann wrote:
> Hi.
>
> I guess your "problem" comes from the fact that SQL has no concept of
> internal order. If you do not specify an ORDER BY clause, the order or
> records returned is undefined, i.e. random.
That's what I was figuring. I asked because I wanted it con
Hi.
I guess your "problem" comes from the fact that SQL has no concept of
internal order. If you do not specify an ORDER BY clause, the order or
records returned is undefined, i.e. random.
Of course, MySQL has some kind of internal order depending on many
factors, but you may not rely on it. And
