题目地址:https://leetcode.com/problems/swap-salary/
题解:交换salary表中的sex,用到if语句,解释一下,if(a,b,c):如果a成立则执行b,否则执行c
update salary set sex = if(sex='m','f','m')
题目地址:https://leetcode.com/problems/swap-salary/
题解:交换salary表中的sex,用到if语句,解释一下,if(a,b,c):如果a成立则执行b,否则执行c
update salary set sex = if(sex='m','f','m')