MySQL Share

---

reset AUTO_INCREMENT in MySQL

by admin

 at 2016-06-19 13:00:00.

if you want to reset the AUTO_INCREMENT in MySQL you can run this command:

ALTER TABLE tablename AUTO_INCREMENT = 1

or if have all ready data in a database and you want to skip some numbers you can change the number 1 to anything you want.