SQL中更新:
UPDATE...
SET...
交换两个数用异或.
# Write your MySQL query statement below update salary set sex = CHAR(ASCII('f') ^ ASCII('m') ^ ASCII(sex));
SQL中更新:
UPDATE...
SET...
交换两个数用异或.
# Write your MySQL query statement below update salary set sex = CHAR(ASCII('f') ^ ASCII('m') ^ ASCII(sex));
转载于:https://www.cnblogs.com/zywscq/p/10657127.html