/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

11 votes131 views4 answers
How to remove NULL values in array PHP
PHP
0 vote145 views1 answer
$age = 20; print ($age >= 18) ? "Adult" : "Not Adult";
PHP
0 vote114 views1 answer
Ipv6 pregmatch
PHP
2 votes162 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote126 views1 answer
Doctrine orm refresh
PHP
0 vote152 views1 answer
Yii2 gridview action change urls
PHP
0 vote161 views1 answer
Link acf
PHP
16 votes171 views6 answers
Laravel run migration
PHP Laravel
10 votes147 views3 answers
Php artisan see last migration
PHP
1 vote191 views1 answer
Laravel set config value dynamically
PHP