Mysql auto_increment field

[Anon]

Hi All,

as you know, after we delete last 10 rows from a table which has an
auto_increment field then if we insert another one or more data, the
auto_increment id will continue from the last 10 deleted datas id. if we
would like to continue id from the last id, how could do this even mysql
shell.

Thanks All,

Mesut...

[kparker]

if we would like to continue id from the last id, how could do this

Since that isn't at all what auto_increment is trying to do, the answer is you are on your own. It's not at all difficult to get what you want, mind you, but merely performance-killing:

   [in pseudocode]
   lock table(s)
   query for the max value of the ID column
   retrieve that value
   insert the new row using ID+1
   unlock table(s)

And note that this does nothing for reusing ID's that are freed by deleting rows from the middle of the table. I won't bother showing that one because it's far worse than the simple case above.

[arnihr]

Why do you want to make the ID's in order?
That's what they're for; have a order on rows... that's just stupid to make them in simple order...