ALTER TABLE `table_name` AUTO_INCREMENT=1
You can also do this in phpMyAdmin without writing SQL.
Click on a database name in the left column.
Click on a table name in the left column.
Click the “Operations” tab at the top.
Under “Table options” there should be a field for AUTO_INCREMENT (only on tables that have an auto-increment field).
Input desired value and click the “Go” button below.
