adding new record to the AUTO_INCREMENT column

Asked Apr 30 '14 at 12:20

Active Apr 30 '14 at 12:22

Viewed 39 times

I created an AUTO_INCREMENT column(id) primary key. When a record is deleted from the table and a new record is added,the id's value automatically gets set to 1 more than the value of previous id.

i want the new record to take the previously left space created by the old deleted id instead of it occupying a new space.

asked Apr 30 '14 at 12:20

shibu

Check out http://stackoverflow.com/questions/18692068/will-mysql-reuse-deleted-ids-when-auto-increment-is-applied – Karl Viiburg Apr 30 '14 at 12:22
2

Why? The purpose of an auto-incremented primary key is to uniquely identify each row. Gaps should not be an issue. – Gordon Linoff Apr 30 '14 at 12:22
Check http://stackoverflow.com/questions/2214141/mysql-auto-increment-after-delete – martian Apr 30 '14 at 12:23

adding new record to the AUTO_INCREMENT column

0 Answers0