update hh set risk_level =(CASE WHEN value >15 THEN "HIGH"
WHEN value <15 and value >10 THEN "MIDDLE"
WHEN value <10 THEN "LOW" END ) WHERE relation_type="OINT"
sql 列值不同情况下的列更新sql
最新推荐文章于 2023-09-04 07:30:00 发布
update hh set risk_level =(CASE WHEN value >15 THEN "HIGH"
WHEN value <15 and value >10 THEN "MIDDLE"
WHEN value <10 THEN "LOW" END ) WHERE relation_type="OINT"