/PHP/Reset id auto increment after deleting a table row in phpmyadmin

Reset id auto increment after deleting a table row in phpmyadmin

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;

0

Similar codes

25 votes272 views1 answer
Php online editor
PHP
0 vote325 views1 answer
Iqbal Laravel save record in two table in one line
PHP Laravel
3 votes264 views2 answers
Error: Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
3 votes258 views2 answers
Replace all occurrence char in string php
PHP
0 vote274 views1 answer
Php copyright footer
PHP
-1 vote308 views2 answers
String and number laravel faker
PHP Laravel
3 votes247 views3 answers
Php remove after character
PHP
0 vote316 views1 answer
Doble quotes in csv export php
PHP
28 votes291 views12 answers
Laravel middleware
PHP Laravel
0 vote246 views1 answer
Modal Edit Specific/Same table row, where button is
PHP

Share