使用 join 而不是 :

UPDATE product_prices pp LEFT JOIN
       Products p
       ON p.name = pp.anme and p.Category_ID = 3
    SET pp.Price = pp.Price * 1.1
WHERE p.Name IS NULL AND pp.Price < 10;

问题是对正在更新的表的操作，而不是视图定义.

The issue is the operation on the table being updated, not the view definition.