/PHP/How to auto increment id after delete value in php mysql

How to auto increment id after delete value in php mysql

SET @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE tableName AUTO_INCREMENT = 1;

/*************     OR     ***********/
ALTER TABLE table_name AUTO_INCREMENT=1

Similar codes

0 vote335 views1 answer
Iterate over assets container statamic
PHP
3 votes368 views2 answers
Laravel 7 view @php
PHP Laravel
3 votes324 views1 answer
Wordpress page template
PHP
0 vote323 views1 answer
How exactly works prompt parameter wp skipping password
PHP
0 vote323 views1 answer
Send data with href
PHP
0 vote434 views1 answer
Cakephp 4 authentication
PHP CakePHP
0 vote322 views1 answer
Class 'Dompdf\Dompdf' not found
PHP
0 vote372 views1 answer
Php file_put_contents inode problem
PHP
0 vote335 views1 answer
Create if not exist laravel
PHP Laravel
4 votes382 views2 answers
Auth guard (admin) is not defined laravel 8
PHP Laravel