/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

11 votes187 views6 answers
Route laravel
PHP Laravel
0 vote161 views1 answer
Date format in wordpress post
PHP
1 vote215 views1 answer
E: Unable to locate package php7.2-mbstring
PHP
-1 vote183 views1 answer
Php get error
PHP
0 vote158 views1 answer
Wp order archive page post by title
PHP
1 vote162 views4 answers
In_array validation laravel
PHP Laravel
0 vote161 views1 answer
Serve https with php local
PHP
4 votes155 views1 answer
How run phpunit test repeat
PHP
1 vote139 views1 answer
How match array in laravel collection
PHP
-1 vote171 views2 answers
Laravel eloquent update multiple records
PHP Laravel