交换数据库中的两条记录

mysql> select * from student;
+----+-------+-----+
| id | name  | age |
+----+-------+-----+
|  1 | root  |  10 |
|  2 | admin |  20 |

+----+-------+-----+

mysql> select * from student as s1  join student s2 on(s1.id=1 and s2.id=2) or (s1.id=2 and s2.id=1);
+----+-------+-----+----+-------+-----+
| id | name  | age | id | name  | age |
+----+-------+-----+----+-------+-----+
|  2 | admin |  20 |  1 | root  |  10 |
|  1 | root  |  10 |  2 | admin |  20 |
+----+-------+-----+----+-------+-----+

mysql> update student s1 join student as s2 on(s1.id=1 and s2.id =2) or (s1.id=2 and s2.id=1)
    -> set s1.name = s2.name,s2.name=s1.name,s1.age = s2.age,s2.age = s1.age;
Query OK, 2 rows affected
Rows matched: 4  Changed: 2  Warnings: 0


mysql> select * from student;
+----+-------+-----+
| id | name  | age |
+----+-------+-----+
|  1 | admin |  20 |
|  2 | root  |  10 |
+----+-------+-----+
2 rows in set