Mysql auto_increment bug or feature ?

admin

Administrator
Staff member
Problem description:
I have a table, with an auto_increment column(id).
I insert a record, so I will have id=1.
I delete the record, and then I try another insert, the id isn't 1, but 2, like the first record is still there.

The question is, is this a bug or a feature? If it is a feature, can somebody explain it to me ?
Thanks in advance.
 
Back
Top