Reset ID autoincrement ? phpmyadmin

Question

Hi, I was testing some data in my tables of my database, to see if there was any error, now I cleaned all the testing data, but my id (auto increment) does not start from 1 anymore, can (how do) I reset it ?

Sorry for any mistake in English, and thanks for the attention.

Answer 1

ALTER TABLE `table_name` AUTO_INCREMENT=1

Answer 2

ALTER TABLE xxx AUTO_INCREMENT =1; or clear your table by TRUNCATE