Automatically add after deleting from table

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  
+5
source share
2 answers

. 2 1 2 2, 3.

, .

, , . , "".

0

All Articles