PHP

php myadmin reset auto incremente

ALTER TABLE table_name AUTO_INCREMENT=0

phpmyadmin reset auto_increment

In phpMyAdmin, select the table you want to change the options from.
Then click on the "Operations" button at the top of the website
There, change your "AUTO_INCREMENT" value to something greater than
the highest value of your table and press the "OK" button.

reset id auto increment after deleting a table row in phpmyadmin

SET @autoid :=0; 
UPDATE table_name SET id = @autoid:=(@autoid+1);
ALTER TABLE table_name AUTO_INCREMENT=1;