Reset Auto Increment in phpmyadmin after Delete 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;
SET @autoid :=0;
UPDATE table_name SET id = @autoid:=(@autoid+1);
ALTER TABLE table_name AUTO_INCREMENT=1;