I want to update the column value in multi-rows insert SQL.
INSERT INTO `product_price` (`product_id`, `store_id`,`price`) VALUES (20001, 1, `price`+10), (4442, 1, `price`-5), (2442, 1, `price`*1.1), (3002, 1, 399), ON DUPLICATE KEY UPDATE `price` = VALUES(`price`);
Where you can see, I want to update the price by some constant value or by some self updates (+, -, *, /).
But it doesn't work in case of
INSERT (works fine in
How to make it workable in
FYI, I am using MySQL 5.7.