/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 vote197 views1 answer
Encryp with codeigniter 3
PHP CodeIgniter
1 vote213 views3 answers
Difference between guard and fillable laravel
PHP Laravel
1 vote207 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
134 votes301 views6 answers
Php find if string contains
PHP
0 vote203 views1 answer
How to increase the WordPress Multisite Network limit for Maximum Filesize Upload?
PHP Wordpress
0 vote158 views1 answer
Vscode open php tag autocomplete
PHP
0 vote230 views1 answer
Drupal 7 hook_form_alter
PHP Drupal
1 vote173 views2 answers
Laravel print request data
PHP
0 vote200 views2 answers
Get post date and time in wordpress
PHP Wordpress
0 vote193 views1 answer
Laravel response json status 500
PHP Laravel