phpmyadmin reset auto increment to 1 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;