/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

6 votes260 views4 answers
Laravel base url
PHP
0 vote306 views1 answer
Require and include difference in laravel
PHP Laravel
0 vote224 views1 answer
How to pass js formdata to php
PHP
1 vote304 views1 answer
Laravel blade form old value
PHP Laravel
0 vote288 views4 answers
Share var in a maser layout laravel
PHP Laravel
2 votes261 views1 answer
Php array move first element to last
PHP
0 vote274 views1 answer
Fetch values and display in bar chart php mysql
PHP
0 vote250 views1 answer
Php unsupported file types
PHP
4 votes320 views3 answers
Laravel 8 check if null or empty
PHP Laravel
4 votes254 views1 answer
Ubuntu set alternatives
PHP