OJ-Problems-Source/LeetCode/627_jzf.sql

3 lines
71 B
MySQL
Raw Permalink Normal View History

2018-06-20 23:13:48 +08:00
update salary
set sex = case when sex ='m' then 'f' else 'm' end;