fastadmin菜单快速排序

• 作者: liujihong
• 时间: 2026-10-02
• 分类: fastadmin
• 暂无评论

select concat('update ck_auth_rule set weigh = ',rn,' where id = ',id,';') as sql_text
  from (select id,pid,
               100 - row_number() over(partition by pid order by id) as rn
          from ck_auth_rule ) t ;