627. Swap Salary
来源:互联网 发布:淘宝 一件代发 编辑:程序博客网 时间:2024/06/05 20:20
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 |
# Write your MySQL query statement belowUPDATE salary SET sex = CASE sex WHEN 'f' THEN 'm' ELSE 'f' END;
阅读全文
0 0
- 627. Swap Salary
- [leetcode]627. Swap Salary
- 627. Swap Salary
- 【LeetCode】627. Swap Salary
- 【leetcode】627. Swap Salary
- 627. Swap Salary
- 627. Swap Salary
- LeetCode-627. Swap Salary
- 627.SWAP Salary
- [LeetCode] 627.Swap Salary
- LC 627. Swap Salary
- sql leetcode 627. Swap Salary
- 627. Swap Salary--UPDATE and CASE...WHEN
- leetcode627. Swap Salary
- 【LeetCode】627、Swap Salary
- 8.leetCode627: Swap Salary
- LeetCode——627. Swap Salary(数据库,sql)
- 627. Swap Salary+编程中早晚用到的|、||、&、&&、异或、~、!运算
- 第二周函数参数传递的三种方式
- 二叉搜索树代码
- [LeetCode]15. 3Sum
- java nio file 内存映射文件
- 最新阿里大于短信验证码node koa2的实现
- 627. Swap Salary
- JAVA设计模式之单例模式
- 第二周 函数参数传递的三种方式
- 一次Mysql死锁排查过程的全纪录
- 漏洞挖掘-混浠的代码
- Tomcat 怎么停止服务的?
- Enable exfat format on Ubuntu 16.04
- java路径问题之一
- Data-driven tight frame construction and image denoising