sql - MySQL: How to efficiently bulk upsert rows, based on previous value?

Question

So let's say I have a table prices:

key	cost
'a'	5
'c'	6

question from:https://stackoverflow.com/questions/65885268/mysql-how-to-efficiently-bulk-upsert-rows-based-on-previous-value

Answer 1

You can use VALUES() to use the value being inserted:

ON DUPLICATE KEY UPDATE products.cost = VALUES (cost)

I'm not sure why you are bothered by the JOIN. It does what you intend.