UPDATE graduates
SET income =
CASE
WHEN income = 20000 THEN
income * 0.5
WHEN income = 15000 THEN
income + 500
ELSE income
END;
mysql update case when的使用
最新推荐文章于 2024-08-26 10:49:43 发布
UPDATE graduates
SET income =
CASE
WHEN income = 20000 THEN
income * 0.5
WHEN income = 15000 THEN
income + 500
ELSE income
END;