Frank,
my experience MySQL returns the the rows in the order that you inserted them
This is true, if, and only if you have never deleted a record from the table.
Like most SQL servers, MySQL leaves deleted records' space in the physical
table unoccupied, but still available. When you insert
I am aware of that.
But from my experience MySQL returns the the rows in the order that you
inserted them.
Assuming this is the case, I was wondering if the result I have seen means
that the order of autoincrement values does not correspond to the order in
which inserts are done.
Frank
On