| 123456789101112131415161718 |
- 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 (
- '辐照度曲线',
- '光伏温度',
- '光伏风速',
- '光伏风向',
- '光伏湿度',
- '光伏气压'
- );
|