描述
Given a table salary
, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a single update query and no intermediate temp table.
For example:
1 | | id | name | sex | salary | |
After running your query, the above salary table should have the following rows:
1 | | id | name | sex | salary | |
分析
注意是更新表,不是 SELECT,这个 CASE 的语法用得少,可以多看一下
解决方案(MySQL)
1 | # Write your MySQL query statement below |