/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 vote286 views1 answer
Wc php get shipping address street
PHP
0 vote317 views1 answer
Laravel create coma separated string from query
PHP Laravel
15 votes284 views4 answers
Remove space from start and end of string in php
PHP
3 votes346 views1 answer
Laravel RuntimeException Session store not set on request.
PHP Laravel
0 vote274 views1 answer
Wordpress add_action echo on edit page
PHP
0 vote330 views1 answer
Post type taxonomy loop wordpress
PHP
4 votes282 views2 answers
Laravel migration update table column type
PHP
17 votes296 views5 answers
Wordpress debug mode
PHP
2 votes296 views3 answers
Laravel subdays
PHP Laravel
0 vote273 views1 answer
Using laravel passport with mongodb
PHP