Leetcode 627. Swap Salary

SQL中更新:

UPDATE...

SET...

交换两个数用异或.

# Write your MySQL query statement below
update salary set sex = CHAR(ASCII('f') ^ ASCII('m') ^ ASCII(sex));

 

posted @ 2019-04-04 21:21  周洋  阅读(91)  评论(0编辑  收藏  举报