Reset auto_increment table

[BrianM]

Is there a way to reset an auto_increment table without having to rebuild and apply a new structure?

[kbh43dz_u]

Try

ALTER TABLE tablename AUTO_INCREMENT = 1

It should set auto increment to the number of your last entry + 1. (Setting it to 0 when you have entries will not work )

I hope I could help you.

 

 

edit: if you want to add an entry with an auto increment number which you deleted before you can use:

SET insert_id = 8;
INSERT INTO tablename VALUES (’field1’, '…');

(for example if you have entries from 0 to 10 but deleted entry number 8 )

[fenway]

Is there a way to reset an auto_increment table without having to rebuild and apply a new structure?

I don't think you want to.