Re: auto_increment not in order

[Guelphdad Lake]

a database table is not a flat file. you can't expect a particular order without an order by clause as noted. the database itself will decide where to insert a new row, it may not be inserted at the "end" of the table so don't rely on that.

also if you have deleted the row with id=3 the rest of the rows don't automatically change their id.

you should be using an auto_increment column for uniqueness only (most often when you don't have a suitable natural key for the table) and not rely on it to be in a certain order for your application code, though many people confuse that point.

---------------
Guelphdad,
Moderator
forums.mysql.com