set @rownum:=10000000;
update aos_dic t1,(select @rownum:=@rownum + 1 as rownum,id from aos_dic order by dic_key) t2 set t1.id = t2.rownum where t1.id = t2.id
update aos_dic set id = id - 10000000
mysql id重排
最新推荐文章于 2024-03-26 18:54:49 发布
set @rownum:=10000000;
update aos_dic t1,(select @rownum:=@rownum + 1 as rownum,id from aos_dic order by dic_key) t2 set t1.id = t2.rownum where t1.id = t2.id
update aos_dic set id = id - 10000000