/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 vote365 views2 answers
Laravel orm tutorial
PHP Laravel
0 vote331 views1 answer
How to add page link in laravel
PHP
16 votes331 views4 answers
Laravel auth helper function
PHP
0 vote324 views1 answer
Laravel array length
PHP
13 votes361 views1 answer
Create contoller with model and migration
PHP
3 votes356 views1 answer
Execute function php
PHP
21 votes308 views3 answers
Php remove element from array by value
PHP
1 vote319 views3 answers
Laravel destroy or delete
PHP
1 vote361 views1 answer
Laravel string builder
PHP Laravel
9 votes357 views2 answers
How to Log Query in Laravel
PHP