how to auto increment id after delete value in php mysql

Solutions on MaxInterview for how to auto increment id after delete value in php mysql by the best coders in the world

Search
showing results for - "how to auto increment id after delete value in php mysql"
Daniel
17 Jan 2017
1SET @num := 0;
2
3UPDATE your_table SET id = @num := (@num+1);
4
5ALTER TABLE tableName AUTO_INCREMENT = 1;
6
7/*************     OR     ***********/
8ALTER TABLE table_name AUTO_INCREMENT=1 
9
similar questions
php increment variable by 1php increment variablephp myadmin reset auto incrementereset id auto increment after deleting a table row in phpmyadminhow to create auto select total amount after adding quantity and price in jquery and php mysqlhow to delete empty rows in phpmyadminphp insert update delete
queries leading to this page
how to get auto increment id when delete the id phpjpa reset auto increment after delete postgresauto increment in php my admin on deletehow to auto increment id after delete value in php mysqlreset auto increment phpmyadminhow to make my records start from one again after deletion in mysqlhow to auto increment id after delete value in php mysql