How to reset AUTO_INCREMENT in MySQL?

[yehlu]

https://stackoverflow.com/questions/892 ... t-in-mysql

代碼: 選擇全部

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;