update USER set gongzi = case
WHEN gongzi < 2000 THEN gongzi * 1.3
WHEN gongzi >= 2000 THEN gongzi * 1.15
END
MySQL根据同一字段不同条件执行更新操作
最新推荐文章于 2024-08-11 09:42:01 发布
update USER set gongzi = case
WHEN gongzi < 2000 THEN gongzi * 1.3
WHEN gongzi >= 2000 THEN gongzi * 1.15
END