at first I wanted to update a table (product prices) by importing a csv file but I don't think that is possible.
So I created a temporary table and imported 2 columns: products_id, products_price
I think tried running this sql:
UPDATE products p SET p.products_price=(
FROM temp_table t
You can use a update join query like
UPDATE products p JOIN temp_table t ON t.products_id=p.products_id SET p.products_price = t.products_price;