Question : reset ids in mysql
Answered by : cute-crayfish-tp9k4ipa1itq
ALTER TABLE table_name AUTO_INCREMENT = 1;
Source : | Last Update : Wed, 11 Mar 20
Question : mysql reset auto increment id
Answered by : important-ibis-wu0u478yd5yk
SET @num := 0;
UPDATE your_table SET id = @num := (@num+1);
ALTER TABLE your_table AUTO_INCREMENT =1;
Source : https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql | Last Update : Wed, 17 Jun 20
Question : mysql id reset
Answered by : jolly-jackal-j9229l0sfxvm
SET @num := 0;
UPDATE your_table SET id = @num := (@num+1);
ALTER TABLE your_table AUTO_INCREMENT =1;
Source : | Last Update : Fri, 15 Apr 22