/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 vote135 views1 answer
Php check if type is mysqli_result
PHP
0 vote118 views1 answer
Image_lib codeigniter add _thumb
PHP CodeIgniter
1 vote162 views1 answer
Db raw update laravel
PHP
3 votes152 views2 answers
Codeigniter validation text length
PHP
7 votes149 views4 answers
$errors show this error in laravel
PHP Laravel
3 votes133 views1 answer
How validate array in laravel in request
PHP
0 vote149 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
10 votes145 views3 answers
Open json file php
PHP
0 vote233 views1 answer
Symfony call service in controller
PHP Symfony
1 vote282 views2 answers
Get all values inside session laravel
PHP