/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 vote313 views1 answer
Setup laravel on AWS
PHP
0 vote276 views2 answers
Laravel storage link without command line
PHP
3 votes292 views2 answers
Laravel tinker generate password
PHP
0 vote264 views3 answers
Br2nl
PHP
1 vote280 views1 answer
Laravel difference between fill and update
PHP
0 vote265 views1 answer
JQuery is not defined load-scripts.php
PHP
33 votes306 views6 answers
How to run a specific migration in laravel
PHP Laravel
13 votes287 views6 answers
How to redirect to another page in php
PHP
1 vote293 views1 answer
Return response array laravel
PHP Laravel
0 vote358 views1 answer
Laravel collective form include image
PHP Laravel