update salary set sex=if(sex='f','m','f')
评论区一种惊奇解法:
update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));
leetcode sql No.627 交换工资
最新推荐文章于 2022-04-18 13:54:03 发布
update salary set sex=if(sex='f','m','f')
评论区一种惊奇解法:
update salary set sex = char(ascii('m') + ascii('f') - ascii(sex));