reset auto increment value in sql table without truncating it code example

ALTER TABLE tmp AUTO_INCREMENT = 3;