IT Answers Not just another web development blog

Mysql delete all rows and reset autoincrement

delete all the rows of a mysql talble

delete from tablename

reset the auto increment key

ALTER TABLE tablename AUTO_INCREMENT=0