/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

3 votes200 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
0 vote187 views1 answer
Phpmyadmin mysql execution time
PHP
0 vote161 views1 answer
Php page sends cookie to visitor
PHP
0 vote160 views1 answer
No captcha laravel
PHP
0 vote216 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel
1 vote165 views1 answer
Parameterized function in php
PHP
0 vote165 views6 answers
Php to python converter online free
PHP
46 votes258 views6 answers
Add column to migration laravel
PHP Laravel
7 votes194 views6 answers
Show featured image in post wordpress
PHP Wordpress
18 votes156 views4 answers
Array value search in php
PHP

Share