1
2
3
4
5
6
7
8

-- @Title: 变更性别 (Swap Salary)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 14:09:53
-- @Runtime: 175 ms
-- @Memory: 0 B
# Write your MySQL query statement below
update  salary 
set sex = char(ascii(sex)^ascii('f')^ascii('m'))