ALTER TABLE tablename AUTO_INCREMENT = 1 https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql