/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 vote229 views3 answers
Cpanel email to email send with php
PHP
0 vote265 views1 answer
Wp post view1
PHP Wordpress
0 vote261 views4 answers
Date format change in laravel blade
PHP
42 votes223 views6 answers
Laravel 8 foreign key
PHP Laravel
13 votes266 views3 answers
How to change existing migration laravel
PHP Laravel
0 vote223 views1 answer
How to create and access angular HTTP params in PHP
PHP
0 vote253 views1 answer
How to pass variable to an event listener laravel
PHP Laravel
0 vote230 views6 answers
Create global function laravel
PHP
1 vote251 views2 answers
Laravel log to console
PHP Laravel
1 vote213 views1 answer
Laravel model find one
PHP Laravel