mysql要实现两列数据互换,适用于多行,例子如下: UPDATE `user` AS a, `user` AS b SET `a`.`user_name` = `b`.`pass_word`, `a`.`pass_word` = `b`.`user_name` WHERE `a`.`id` = `b`.`id`; 注意: 必须要存在主键的连接条件!