SET @i=0;
UPDATE `表名` SET `id`=(@i:=@i+1);
ALTER TABLE `表名` AUTO_INCREMENT=0;
Last modification：April 12, 2022
© Allow specification reprint
Appreciate the author
如果觉得我的文章对你有用，请随意赞赏