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 ;