重新排序

最新推荐文章于 2020-04-18 08:42:33 发布

weixin_33910434

最新推荐文章于 2020-04-18 08:42:33 发布

阅读量157

点赞数

CC 4.0 BY-SA版权

文章标签： python 数据库

原文链接：https://my.oschina.net/u/2285090/blog/1587983

2019独角兽企业重金招聘Python工程师标准>>>

MySql:
update sys_dict sd,
(select d.id,d.sort ,@rownum:=@rownum+1 as rowid
from (select @rownum:=0) a, sys_dict d
order by d.sort) newSort
set sd.sort = ((newSort.rowid)*10)
where sd.id = newSort.id

sqlServer:
update sd set sd.sort = (newSort.rowid)*10
from sys_dict sd,
(select ROW_NUMBER() over (order by sort) as rowid,id,sort from sys_dict) newSort
where sd.id = newSort.id

Oracle:
update sys_dict sd
set sd.sort = (select newSort.rn
from(select id,sort,rownum*10 as rn from sys_dict)newSort
where sd.id = newSort.id)

转载于:https://my.oschina.net/u/2285090/blog/1587983