/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

23 votes142 views2 answers
Serve php file
PHP
4 votes177 views5 answers
Laravel get first record
PHP Laravel
0 vote194 views1 answer
Wordpress display post categories
PHP
0 vote199 views1 answer
Doble quotes in csv export php
PHP
2 votes234 views2 answers
Wordpress activate plugins
PHP Wordpress
0 vote195 views1 answer
New in initializers - PHP 8.1
PHP
2 votes154 views1 answer
Codeigniter row count returns 1 always
PHP CodeIgniter
1 vote154 views1 answer
Php close session
PHP
44 votes153 views6 answers
Php array size
PHP
0 vote140 views1 answer
Get nearby from longitude and latitude in laravel
PHP

Share