/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

2 votes281 views2 answers
Laravel abort with message
PHP
0 vote303 views1 answer
Laravel automatically generate unique username
PHP
1 vote309 views3 answers
Php dump
PHP
3 votes340 views2 answers
Laravel longblob migration
PHP Laravel
0 vote298 views1 answer
Auto complete order paid3
PHP
4 votes308 views2 answers
Pakistan standard time zone
PHP
0 vote296 views1 answer
Carbon greater than
PHP
0 vote296 views1 answer
Limit wordpress search to title
PHP
0 vote293 views1 answer
Docker php-fpm-apline add imagick
PHP
17 votes295 views6 answers
Laravel return validation errors
PHP