commit 2376d6f51a7d306c27626a75effb2c13398b92be parent ed91d32af427a2eb5073440e0ad809711041c5f2 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Thu, 13 Jul 2023 19:42:38 -0500 Completed swap salary with mySQL Diffstat:
| A | swap-salary/swap-salary.sql | | | 7 | +++++++ |
1 file changed, 7 insertions(+), 0 deletions(-)
diff --git a/swap-salary/swap-salary.sql b/swap-salary/swap-salary.sql @@ -0,0 +1,7 @@ +--Given a table update all +--sexes to the opposite +UPDATE Salary +SET Salary.sex = CASE + WHEN Salary.sex = 'm' then 'f' + WHEN Salary.sex = 'f' then 'm' +END