[leetcode]627. Swap Salary
来源:互联网 发布:淘宝实名账号购买 编辑:程序博客网 时间:2024/06/05 18:42
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.
| id | name | sex | salary ||----|------|-----|--------|| 1 | A | m | 2500 || 2 | B | f | 1500 || 3 | C | m | 5500 || 4 | D | f | 500 |After running your query, the above salary table should have the following rows:
| id | name | sex | salary ||----|------|-----|--------|| 1 | A | f | 2500 || 2 | B | m | 1500 || 3 | C | f | 5500 || 4 | D | m | 500 |
Solution:
# Write your MySQL query statement below
update salary set sex=IF(sex='m','f', 'm')
阅读全文
1 0
- [leetcode]627. Swap Salary
- 【LeetCode】627. Swap Salary
- 【leetcode】627. Swap Salary
- LeetCode-627. Swap Salary
- [LeetCode] 627.Swap Salary
- sql leetcode 627. Swap Salary
- 【LeetCode】627、Swap Salary
- 627. Swap Salary
- 627. Swap Salary
- 627. Swap Salary
- 627. Swap Salary
- 627.SWAP Salary
- LC 627. Swap Salary
- LeetCode——627. Swap Salary(数据库,sql)
- 627. Swap Salary--UPDATE and CASE...WHEN
- leetcode627. Swap Salary
- 8.leetCode627: Swap Salary
- 【LeetCode】Second Highest Salary && Nth Highest Salary
- 【Kotlin】Kotlin与Java反射实践
- Ryu控制器部署及其与Rest API接口调用问题解决
- 量化投资
- PAT乙级 1050. 螺旋矩阵(25)
- matlab初级
- [leetcode]627. Swap Salary
- shell中的eval以及与 反引号``、$()的区别
- 支持向量机(SVM)
- Android Webview 软键盘遮挡输入框
- sacla(1)----- 简介及安装
- CentOS下安装mysql5.7.18的正确姿势
- getDrawable过时的替代方法
- 一篇非常不错的前端面试文章
- PAT乙级 1051. 复数乘法 (15)