search

Resetting the AUTO_INCREMENT value in MySQL


How do I remove all data from a table and reset the AUTO_INCREMENT value back to 1?


TRUNCATE database_name.table_name

 

close
search

Hi, guest!

settings

menu