Answers for "how to reset an auto increment back to 0 in a table phpmyadmin"

PHP
1

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.
Posted by: Guest on October-07-2021
0

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;
Posted by: Guest on January-27-2021

Code answers related to "how to reset an auto increment back to 0 in a table phpmyadmin"

Browse Popular Code Answers by Language