SQL 前端排序 更新至数据库 参考代码

UPDATE md_drainage_basin
    SET sort_order = CASE id
        WHEN 5 THEN sort_order+1
        ELSE sort_order-1
    END
  WHERE id IN 
   ( select * FROM (SELECT id  FROM md_drainage_basin  t1 WHERE t1.sort_order=(SELECT sort_order FROM md_drainage_basin  WHERE id=5)+1 OR t1.id=5 ) ids)