1 题目描述 2 解题思路 用case…when case用法: case a when cond1 then exp1 else cond2 then exp2 else exp3 当a满足条件cond1时, 返回exp1 当a满足条件cond2时, 返回exp2 否则 返回exp3 3 解决代码 # Write your MySQL query statement below update salary set sex = ( case sex when'm' then 'f' else 'm' end )