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/
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/