Auto_increment question

[steijssen]

Hi,

I have a table with an auto_increment field. When I delete a row, and insert a new one, it continues to count as if the row was never deleted. Count: 1,2,3,4 delete 4, insert new record, it counts on like 1,2,3,5

Question is can I reset this, so that next time, it starts at 4 again?
I know you can reset an auto_increment with the delete from table query, but I need to keep the current records..

 

[cibrran]

You don't keep them....

The only solution just that delete your table.