mysql - 使用子查询删除显示 #1064 错误

Question

此查询显示 #1064 错误。

DELETE FROM product_price AS pp
WHERE pp.PRODUCT_ID IN (
    SELECT PRODUCT_ID
    FROM (
        SELECT P.PRODUCT_ID
        FROM product p
        WHERE p.PRODUCT_NAME='watch') t
)

Answer 1

使用 JOIN 而不是这样的子查询；)

DELETE pp FROM product_price AS pp
INNER JOIN product p ON pp.PRODUCT_ID = p.PRODUCT_ID AND p.PRODUCT_NAME='watch'