SET @i=0; UPDATE `tablename` SET `id`=(@i:=@i+1); ALTER TABLE `tablename` AUTO_INCREMENT=0
posted on 2020-01-24 13:22 pinked 阅读(1473) 评论(0) 编辑 收藏 举报
Powered by: 博客园 Copyright © 2024 pinked Powered by .NET 8.0 on Kubernetes