/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 vote221 views1 answer
Hide plugin update notification wordpress
PHP Wordpress
1 vote187 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP
3 votes176 views3 answers
Seconds to days hours minutes seconds php
PHP
0 vote201 views1 answer
Install php apache
PHP
1 vote190 views1 answer
Strpos codeigniter php 7
PHP
4 votes198 views1 answer
Laravel relation of relation
PHP
0 vote215 views1 answer
$loop laravel list
PHP
5 votes220 views6 answers
New laravel 8 project
PHP Laravel
0 vote208 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP
10 votes220 views4 answers
Isempty php
PHP