/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

-1 vote193 views1 answer
How to call php function from ajax
PHP
0 vote219 views3 answers
Laravel tinker factory
PHP
1 vote216 views1 answer
Inrandomorder laravel
PHP
2 votes230 views2 answers
Wordpress is admin
PHP Wordpress
17 votes265 views3 answers
Debug wordpress
PHP Wordpress
-1 vote229 views3 answers
Install php debian 10
PHP
0 vote252 views1 answer
Job execute async laravel
PHP Laravel
3 votes197 views2 answers
Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
0 vote197 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP
4 votes255 views4 answers
Wordpress get theme uri
PHP Wordpress