/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 vote130 views1 answer
Php backend generator
PHP
5 votes141 views6 answers
Convert String to Float in PHP
PHP
2 votes127 views1 answer
Yii2 migration add column
PHP
0 vote135 views1 answer
Laravel file custom name
PHP Laravel
2 votes146 views1 answer
Wordpress theme development boilerplate
PHP Wordpress
0 vote145 views4 answers
Laravel collection contains
PHP
19 votes131 views4 answers
Php get ip address of visitor
PHP
0 vote121 views2 answers
Php form detect if number has decimals
PHP
0 vote154 views1 answer
Laravel db ssh
PHP Laravel
2 votes175 views2 answers
Create custom rule in laravel
PHP Laravel