msyql两列数据对换

update 表名 as a, 表名 as b set a.列明A=b.列明B, a.列明B=b.列明A where a.列明C=b.列明C;