solve problem Swap Salary

P-ppc · P-ppc · commit 4917f1395e39 · 2018-11-22T01:14:49.000+08:00
diff --git a/README.md b/README.md
@@ -325,4 +325,5 @@ All solutions will be accepted!
 |182|[Duplicate Emails](https://leetcode-cn.com/problems/duplicate-emails/description/)|[mysql](./database/DuplicateEmails)|Easy|
 |596|[Classes More Than 5 Students](https://leetcode-cn.com/problems/classes-more-than-5-students/description/)|[mysql](./ClassesMoreThan5Students)|Easy|
 |620|[Not Boring Movies](https://leetcode-cn.com/problems/not-boring-movies/description/)|[mysql](./database/NotBoringMovies)|Easy|
-|196|[Delete Duplicate Emails](https://leetcode-cn.com/problems/delete-duplicate-emails/description/)|[mysql](./database/DeleteDuplicateEmails)|Easy|
+|196|[Delete Duplicate Emails](https://leetcode-cn.com/problems/delete-duplicate-emails/description/)|[mysql](./database/DeleteDuplicateEmails)|Easy|
+|627|[Swap Salary](https://leetcode-cn.com/problems/swap-salary/description/)|[mysql](./database/SwapSalary)|Easy|
diff --git a/database/SwapSalary/README.md b/database/SwapSalary/README.md
@@ -0,0 +1,2 @@
+# Swap Salary
+We can solve this problem by CASE ... WHEN ... THEN ... END;
diff --git a/database/SwapSalary/solution.sql b/database/SwapSalary/solution.sql
@@ -0,0 +1,2 @@
+# Write your MySQL query statement below
+update salary set sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Swap Salary`
	`2`	`+We can solve this problem by CASE ... WHEN ... THEN ... END;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Write your MySQL query statement below`
	`2`	`+update salary set sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END;`