mysql - 如何将任意列中的属性值乘以 0.20

Question

我有以下查询。如何在以下查询中将价格乘以 0.20？

SELECT e.sku, eav.value AS 'avg margin'
FROM catalog_product_entity e
JOIN catalog_product_entity_decimal eav
  ON e.entity_id = eav.entity_id
JOIN eav_attribute ea
  ON eav.attribute_id = ea.attribute_id
WHERE ea.attribute_code = 'price'

Answer 1

根据您的评论我选择了价格作为平均利润。看起来eav.value是您想要乘以0.2的字段，你可以简单地这样做:

SELECT e.sku, (eav.value * 0.2) AS avg_margin