/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

4 votes270 views2 answers
Cascade in laravel migration
PHP Laravel
1 vote175 views1 answer
Php begin tag
PHP
0 vote137 views2 answers
Http://www.endmemo.com/program/R/vector.php
PHP
3 votes259 views2 answers
Laravel 7 view @php
PHP Laravel
0 vote226 views1 answer
Carbon previous day
PHP
0 vote174 views1 answer
Php remove everything before colon
PHP
0 vote216 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
0 vote191 views1 answer
"^" means in php
PHP
0 vote181 views1 answer
Blade loop last
PHP
2 votes170 views1 answer
Redirect from controller in laravel
PHP