/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 vote169 views1 answer
Uft8 json php
PHP
21 votes188 views5 answers
Laravel 7 auth command
PHP Laravel
0 vote146 views1 answer
Guzzlehttp php basic auth
PHP
2 votes166 views2 answers
Laravel insert timestamp now
PHP Laravel
2 votes140 views1 answer
Laravel asset
PHP
0 vote170 views1 answer
Php throw exception get message
PHP
0 vote217 views1 answer
Php glob sort by unsigned int
PHP
1 vote131 views1 answer
How to stop laravel server
PHP
0 vote146 views1 answer
Ajax search request
PHP
0 vote146 views2 answers
Php curl ssl verify
PHP