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
Poopcode
Code snippets | Coding interview questions with solutions | JavaScript tutorials | Python tutorials