Month: March 2018

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

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