/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

15 votes155 views3 answers
Php strtoupper
PHP
0 vote175 views1 answer
How to remove notice error in php
PHP
2 votes228 views1 answer
Laravel-ckeditor
PHP Laravel
23 votes173 views6 answers
Make auth in laravel 7
PHP
0 vote184 views1 answer
Laravel 7 create-project
PHP
0 vote189 views1 answer
T variable error meaning in php
PHP
0 vote276 views3 answers
Best wordpress functions to include
PHP Wordpress
0 vote141 views1 answer
Pdo example
PHP
0 vote197 views1 answer
Create a exporter in laravel command
PHP
2 votes180 views2 answers
Class "\App\User" not found
PHP