mysql 数据 单条语句更新替换

update salary set
sex = (case sex
when ‘m’ then ‘f’
else ‘m’
end)；
或
update salary set sex=if(sex = ‘f’, ‘m’,‘f’);

参考：https://leetcode-cn.com/problems/swap-salary/solution/tu-jie-sqlmian-shi-ti-ru-he-an-tiao-jian-xiu-gai-s/