从另一个表更新列-mysql 3.5.2

我尝试了几种方法来从另一个表更新MySQL数据库表中的列,但没有任何运气。

我在某个地方读到版本3.5.2不支持多表更新,我需要一个基于代码的解决方案-对吗?

如果没有,有人能用SQL为我指明正确的方向吗?

UPDATE products SET products_ordered = (
    SELECT SUM(products_quantity) 
    FROM orders_products 
    WHERE products_id = products.products_id
);

或:

Create temporary table my_temp_table
as
SELECT products_id, SUM(products_quantity) as total 
FROM orders_products 
GROUP BY products_id 

UPDATE products, my_temp_table
SET products.products_ordered = my_temp_table.total 
WHERE products.products_id = my_temp_table.products_id