I have SQL (MySQL 5.x) query like:
INSERT INTO table (val1),
ON DUPLICATE KEY UPDATE `val1` = VALUES(`val1`)
And this works fine.
Now i need to update it with a sum of VALUES(val1
) + ruby variable.
INSERT INTO table (val1),
ON DUPLICATE KEY UPDATE `val1` = VALUES(`val1`) + #{ruby_variable}
throws me an error.
(Ruby here is just an example, actually i need to sum VALUES(val1
) + integer)
How it could be done?
See Question&Answers more detail:os