UPDATE USER SET
Gender=CASE
WHEN @age=10 THEN 'nan'
WHEN @age=25 THEN 'nu'
WHEN @age=20 THEN '222'
ELSE
gender
END,
NAME= CASE
WHEN @age=10 THEN 'name4'
WHEN @age=25 THEN 'name3'
ELSE NAME
END
WHERE userId='1';
mysql case-when-end 条件语句
最新推荐文章于 2024-06-09 10:02:40 发布