how to reset table auto increment column id in mysql (phpmyadmin) code example
Example: 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;