MySql交换表的两行

hbghlyj

MySql取出tid为210和280的两行, 把它们的fid和subject交换

1. update `forum_thread` a
2. inner join `forum_thread` b on a.tid <> b.tid
3.    set a.fid = b.fid,
4.        a.subject = b.subject
5. where a.tid in (210,280) and b.tid in (210,280)

Copy the Code

输出信息
2 rows affected. (Query took 0.0033 seconds.)
参考资料:
Mysql: Swap data for different rows