/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 vote161 views1 answer
Cakephp group by count
PHP CakePHP
10 votes136 views4 answers
Laravel create
PHP Laravel
0 vote129 views1 answer
Strtotime laravel
PHP Laravel
1 vote132 views1 answer
Str_ireplace
PHP
12 votes135 views2 answers
Debug bar laravel print array
PHP Laravel
1 vote170 views1 answer
Get year in laravel 8
PHP Laravel
0 vote158 views1 answer
Upload image to database laravel 8
PHP Laravel
0 vote121 views1 answer
Php array common element
PHP
0 vote128 views1 answer
Wp wc php out of stock product to bottom
PHP Wordpress
0 vote158 views1 answer
Get datetime of excel cell in codeigniter
PHP CodeIgniter