UPDATE salarySET sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END;
update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));
update salaryset sex = replace("fm", sex, "")
update salary set sex = char(ASCII(sex) ^ ASCII('m') ^ ASCII('f') ) ;
`单行代码`