/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 vote103 views2 answers
Single sign on php script
PHP
1 vote145 views1 answer
Php get data from prepared select
PHP
4 votes70 views3 answers
Sweet alert laravel
PHP
0 vote96 views1 answer
Best version control tools for php
PHP
13 votes106 views5 answers
Php get extension from string
PHP
3 votes132 views1 answer
How to named route resource laravel
PHP Laravel
7 votes133 views3 answers
Laravel - Query Builder Left join
PHP Laravel
2 votes112 views2 answers
Wordpress theme The link you followed has expired.
PHP
0 vote106 views1 answer
Filter child table data from parent laravel eloquent
PHP
0 vote103 views1 answer
Créer projet laravel
PHP