/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

1 vote263 views1 answer
Laravel parent child same table
PHP
0 vote317 views1 answer
Wordpress if is not page template
PHP Wordpress
28 votes238 views5 answers
Php get current year
PHP
0 vote280 views3 answers
Laravel postgres deadlock
PHP Laravel
10 votes283 views4 answers
Compact laravel
PHP
39 votes279 views6 answers
Php uppercase
PHP
4 votes297 views5 answers
Laravel route multiple middleware
PHP Laravel
0 vote255 views1 answer
How to duplicate a database in phpmyadmin
PHP
9 votes298 views6 answers
Laravel validation custom message
PHP Laravel
9 votes258 views4 answers
Datetime format laravel
PHP