sql autoincrement reset code example

Example: sql reset auto increment

ALTER TABLE tmp AUTO_INCREMENT = 3;