/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 vote257 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
-2 votes211 views1 answer
Laravel model bind with route in model
PHP Laravel
1 vote180 views1 answer
Laravel http request plain text
PHP
0 vote165 views1 answer
Php forbidden header
PHP
0 vote315 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
0 vote179 views1 answer
How to check if a user sent you money in paypal in php
PHP
0 vote199 views1 answer
Quitar html con laravel 5
PHP Laravel
0 vote133 views0 answer
PHP
3 votes178 views2 answers
Php permanent redirect to url
PHP
0 vote173 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP