新公司开发的第一个需求是关于交换数据库中不同数据的row值,在不建立临时表的情况下可以尝试下面sql;
UPDATE
user AS user1
JOIN user AS user2 ON
( user1.uid = 1 AND user2 .uid = 2 )
OR ( user1.uid = 2 AND user2 .uid = 1 )
SET
user1.user_name = user2.user_name,
user2.user_name = user1.user_name