search

Month: March 2018


Resetting the AUTO_INCREMENT value in MySQL

Posted by 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  


Changing AUTO_INCREMENT value in MySQL

Posted by in MySQL

How do I change the AUTO_INCREMENT value? ALTER TABLE database_name.table_name AUTO_INCREMENT=5000


close
search

Hi, guest!

settings

menu