Mangeto批量修改价格：把price的值赋值给special price

#把price的值赋值给special price#产品id为888#attribute_id=76的时候value字段表示的是special price价格#attribute_id=75的是value字段表示的是price价格UPDATE catalog_product_entity_decimal as t1INNER JOIN (SELECT entity_id,value FROM catalog_product_entity_decimal where attribute_id=75) as t2SET t1.value=t2.value WHERE t1.entity_id=t2.entity_id and t1.attribute_id=76 and t1.entity_id=888;

#不指定产品id，批量修改UPDATE catalog_product_entity_decimal as t1INNER JOIN (SELECT entity_id,value FROM catalog_product_entity_decimal where attribute_id=75) as t2SET t1.value=t2.value WHERE t1.entity_id=t2.entity_id and t1.attribute_id=76;

#把虚高价格(price价格)上调20%#attribute_id=75的时候value字段的值表示price价格update catalog_product_entity_decimal set value=value*1.2 where attribute_id=75;