Update multiple entries in database query errors

Databases
1

Hello

Hoping someone can help me with this.
I have a table with product pricing info in it.
I also have a list of updated prices for these products.

I’m trying to set up a query which will check the product Id number and update the price in the table with the new one based on it.

This is what I have so far but I think this will only work for an individual product.

UPDATE store.oc_product SET price = ‘354.2’ WHERE oc_product.sku = ‘001102CH’;

Any help would be greatly appreciated with this as there are around 30,000 products to be updated!

Thanks in advance

2

store these in a separate table and then do a joined update