mysql reset table data

CopyTRUNCATE TABLE <tablename>;
ALTER TABLE <tablename> AUTO_INCREMENT = 1;

Alternate to truncate is

DELETE FROM <tablename>;