mysql query to set the autoincrement reset the number to 12 code example Example: mysql reset auto increment value ALTER TABLE table_name AUTO_INCREMENT = 1;