Possible duplicate:
MySQL: reorder / reset primary key with automatic addition?
if I delete ligne from my table, and in this table I have an auto increase identifier, DELETE From the table, where id = 2
after that the table will look as follows
ID | NAme
1 aaa
3 cccc
how can i fix the identifier so that it looks like
ID | NAme
1 aaa
2 cccc
3 dddd
source
share