mysql更新本表的存储过程

暗香浮动，月黑风高

于 2019-12-28 14:22:21 发布

阅读量360

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/xfy18317776108/article/details/103744210

版权

mysql 专栏收录该内容

18 篇文章

订阅专栏

BEGIN
UPDATE tb_department s JOIN (SELECT a.id,@rownum:= LPAD(CAST(@rownum+1 as char(10)),3,0) inde
                  FROM 
                   (SELECT id,parent_order,self_order,parent_id,topid FROM tb_department g where g.parent_id = parentId ORDER BY parent_order asc, self_order asc) a, (SELECT @rownum :='000', @pxydm := NULL,@rank:='000') b) c ON s.id = c.id SET s.self_order=c.inde;
     
#Routine body goes here...

END