how to reset data of auto increment in sql code example

Example: sql reset auto increment

ALTER TABLE tmp AUTO_INCREMENT = 3;