/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 vote140 views1 answer
Wordpress display post categories
PHP Wordpress
1 vote143 views3 answers
Php dump
PHP
0 vote162 views1 answer
Count column eloquent laravel
PHP Laravel
9 votes129 views5 answers
Laravel create password hash
PHP
1 vote152 views2 answers
Insert batch in laravel
PHP Laravel
0 vote155 views1 answer
Set custome table laravel eloquent
PHP Laravel
1 vote125 views1 answer
Laravel 6 tymon/jwt-auth
PHP
0 vote145 views2 answers
How make custom menu in wordpress
PHP Wordpress
0 vote138 views1 answer
Laravel timestamps on pivot table
PHP
0 vote143 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP Laravel