题目来源 LEETCODE 题目描述 题目解析 update salary set sex = if(sex = 'm' , 'f', 'm'); update salary set sex = char(ascii('m') + ascii('f') - ascii(sex)) ; update salary set sex = case sex when 'm' then 'f' when 'f' then 'm' end;