phpmyadmin reset auto increment code example
Example 1: php myadmin reset auto incremente
ALTER TABLE table_name AUTO_INCREMENT=0
Example 2: 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;