/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 vote112 views1 answer
Toggle switch php
PHP
6 votes105 views3 answers
Eloquent relationships
PHP
0 vote98 views2 answers
'ldfdfdf
PHP
0 vote177 views1 answer
Ajouter du contenu personnalisé sous chaque article/publication WordPress
PHP Wordpress
1 vote115 views2 answers
Get database name laravel
PHP
0 vote108 views3 answers
Passing data from controller to blade view laravel
PHP Laravel
16 votes156 views6 answers
Php string to date
PHP
0 vote98 views1 answer
Like %% inside the string php
PHP
1 vote61 views1 answer
Laravel roles
PHP
0 vote106 views2 answers
Laravel santum
PHP