update kaifaqu

update kaifaqu s set id = t.rownum
from (select ROW_NUMBER() OVER() as rownum,name from kaifaqu) as t
where s.name = t.name

posted on 2022-03-02 12:01  苹果园dog  阅读(14)  评论(0编辑  收藏  举报

导航