8.leetCode627: Swap Salary
来源:互联网 发布:淘宝原价和现价步骤 编辑:程序博客网 时间:2024/06/08 19:44
题目: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:
After running your query, the above salary table should have the following rows:
MySQL代码:
update salaryset sex = case sex when 'm' then 'f' else 'm' end
阅读全文
0 0
- 8.leetCode627: Swap Salary
- leetcode627. Swap Salary
- 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
- 【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
- salary
- salary
- vue+swiper 轮播
- js和php 在数组处理上的不同
- kaggle 入门
- SSH无密码登录
- php2python
- 8.leetCode627: Swap Salary
- 用jquery动画隐藏显示文本框
- Topcoder SRM 721 Div.2 A. FlightDataRecorder
- Android 在代码中安装 APK 文件
- ffmpeg滤镜专题2-高斯模糊
- Android 编码规范
- 20170928 使用网页管理集群 按行读取写入useragent txt文件
- script到底应该放在哪里
- CURL访问远程方法