627. Swap Salary--UPDATE and CASE...WHEN
来源:互联网 发布:淘宝散片cpu可靠吗 编辑:程序博客网 时间:2024/05/22 07:41
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 |
Approach: Using UPDATE
and CASE...WHEN
[Accepted]
Algorithm
To dynamically set a value to a column, we can use UPDATE
statement together when CASE...WHEN...
flow control statement.
MySQL
UPDATE salarySET sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END;
阅读全文
0 0
- 627. Swap Salary--UPDATE and CASE...WHEN
- 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
- update case when 問題
- update case when
- update case when
- sql leetcode 627. Swap Salary
- MySql Update与case when
- Case when 与Update语句的使用
- GitHub转华为软件开发云详细教程
- 陆奇最新内部演讲:百度需要的AI工程师,要满足这五大要求
- 众数问题 oj17
- 指针和链表训练题目
- 开源库LitePal的用法
- 627. Swap Salary--UPDATE and CASE...WHEN
- HDU4912 Paths on the tree(数据结构,lca,贪心)
- 如何使用前置声明取代包括头文件
- 那些创意十足的东东们
- Netty之握手和安全认证
- 用于批量对半裁剪jpg格式照片
- 写在毕业一个月之际
- codeblocks安装教程和文件的简单创建方法
- git回滚到上一版本