同表：select * from table where a=b不同表select * from table1,table2 where table1.a=table2.b
UPDATE AA SET BB = CC,CC = BB就这么简单
