reset auto increment counter of the primary key in mysql

alter table foo AUTO_INCREMENT = 1