auto increment alter table set to 1 code example

Example: mysql reset auto increment to 1

ALTER TABLE tablename AUTO_INCREMENT = 1