Resetting Autoincrement

[Karaethon]

I need to reset my autoincrement value, I had a minor goof in my insert code and it ws inserting data wrong, i have fixed it but im now over 1000 rows in and all error posts are deleted, its not a big deal on a bigint but i want to start over at the beginning for my own OCD issues. how/can this be done?

[benanamen]

Truncate the table. It will also delete all the data.

TRUNCATE TABLE table_name; TRUNCATE TABLE table_name;

Edited July 6, 2019 by benanamen

[Karaethon]

Thanks.

[Envrin]

Another way is to simply:

 

ALTER TABLE table_name SET AUTO_INCREMENT=0;

 

Hope that helps.