reset id column in table mysql code example Example: mysql reset auto increment value ALTER TABLE table_name AUTO_INCREMENT = 1;