MySQL Forums
Forum List  »  Docs

Suggested replacement for use of deprecated VALUES() to access new row values in INSERT ... SELECT ... ON DUPLICATE KEY UPDATE statements
Posted by: Jens Hatlak
Date: November 10, 2020 08:57AM

As documented here [1], VALUES() used in ON DUPLICATE KEY UPDATE has been deprecated. Neither [1] nor [2] describe the suggested replacement for INSERT ... SELECT ... ON DUPLICATE KEY UPDATE cases. I also checked the 8.0.19 changes [3].

Was it missed?
Please update the documentation to either state
a) what the suggested replacement is (including examples) or
b) that this use case has been deprecated without suggested replacement

[1] https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-20.html#mysqld-8-0-20-deprecation-removal
[2] https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
[3] https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-19.html

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.