/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

15 votes121 views1 answer
Laravel skip requirements
PHP Laravel
0 vote96 views1 answer
Make_dpcust
PHP
1 vote106 views1 answer
Search on taxonomy wordpress query
PHP Wordpress
0 vote91 views1 answer
Drupal 9 how to pass arguments to custom blocks
PHP
8 votes90 views1 answer
Storage image not showing in laravel
PHP
2 votes108 views2 answers
Phpmailer with laravel
PHP
0 vote96 views1 answer
Folder name escape php
PHP
1 vote73 views1 answer
Wordpress if is in categroy
PHP Wordpress
6 votes115 views3 answers
Laravel bootstrap auth scaffolding
PHP Laravel
0 vote94 views1 answer
Myr currency symbol
PHP