clear auto_increment mysql code example Example: mysql reset auto increment value ALTER TABLE table_name AUTO_INCREMENT = 1;