UPDATE public.sys_menu
SET order_num = CASE menu_name
    WHEN '辐照度曲线' THEN 10
    WHEN '光伏温度'   THEN 20
    WHEN '光伏风速'   THEN 30
    WHEN '光伏风向'   THEN 40
    WHEN '光伏湿度'   THEN 50
    WHEN '光伏气压'   THEN 60
    ELSE order_num
END
WHERE menu_name IN (
    '辐照度曲线',
    '光伏温度',
    '光伏风速',
    '光伏风向',
    '光伏湿度',
    '光伏气压'
);