how to set auto increment in sql back to 1 code example

Example: sql reset auto increment

ALTER TABLE tmp AUTO_INCREMENT = 3;