sql - 使用 INNER JOIN 从 SQL 转换 UPDATE 以便在 MySQL 中使用

Question

我想在 MySQL 中为我们转换它:

UPDATE product 
SET price = 12.95 
FROM product 
    INNER JOIN product_to_category ON product.product_id = product_to_category.product_id 
    INNER JOIN category ON product_to_category.category_id = category.category_id 
        AND category.parent_id = 39

MySQL 不喜欢 FROM 部分，我也不确定 INNER JOIN 是否会像写的那样工作。

Answer 1

UPDATE product 
SET price = 12.95 
WHERE product_id in
(SELECT product_id 
FROM product_to_category 
INNER JOIN category 
ON product_to_category.category_id = category.category_id 
WHERE category.parent_id = 39)