sql auto reset autoincrement code example

Example: sql reset auto increment

ALTER TABLE tmp AUTO_INCREMENT = 3;