使用 LEFT JOINS 进行 MySQL 更新

Question

这是我的查询:

UPDATE 
    `product_pricing` 

SET `formula_id`= '2'

WHERE 1

<小时/>

SELECT

product_pricing.id,
product_pricing.formula_id,
product_pricing.vat_calculated,

products_ids.id,
products_ids.link_id,

product_attributes.fty_id,
product_attributes.size_id,

product_sizes.size_id,
product_sizes.wheel

FROM product_pricing 

LEFT JOIN products_ids ON product_pricing.id = products_ids.id
LEFT JOIN product_attributes ON products_ids.link_id = product_attributes.fty_id
LEFT JOIN product_sizes ON product_attributes.size_id = product_sizes.size_id

WHERE

product_sizes.wheel = '13'

如何将 SELECT 查询与更新查询合并？

我只需要更新具有 product_sizes.wheel = '13' 的产品，但要获取此信息，我需要一些左联接。

Answer 1

您可以将此更新与 LEFT JOIN 和Where 结合使用

update product_pricing 
LEFT JOIN products_ids ON product_pricing.id = products_ids.id
LEFT JOIN product_attributes ON products_ids.link_id = product_attributes.fty_id
LEFT JOIN product_sizes ON product_attributes.size_id = product_sizes.size_id
SET product_pricing.formula_id= '2'
WHERE

product_sizes.wheel = '13'