执行sql :

UPDATE
table表 AS T1 JOIN
table表 AS T2 ON (T1.id = 1 AND T2.id = 2)
SET T1.字段1 = T2.字段1, T2.字段1 = T1.字段1,
T1.字段2 = T2.字段2, T2.字段2 = T1.字段2;

#说明 id=1 和id=2 是两条要替换数据id值