工作中用到的mysql

1、同步数据后发现，两个字段的值错了，需要对换  （sql如下）

#UPDATE  cws_product t1 LEFT JOIN cws_productvariant t2 on t1.id=t2.productId  SET t2.variantValue='2017'  where t1.companyId='8a8694b7603616a0016036270466002b' ;

UPDATE cws_productvariant AS a,
 cws_productvariant AS b
SET a.colour = b.size,
 a.size = b.colour
WHERE a.variantValue='2017' AND
a.id = b.id ;