MySQL Forums
Forum List  »  Docs

Re: 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: March 22, 2021 01:00PM

https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=67069b7ec9cb69ebee644b9c87132968

Since there is no VALUES or SET part after INSERT INTO someTable, there is no way to apply an alias as documented.

Please, when you reply,
1. explain how to adapt INSERT INTO SELECT cases like this
2. update the documentation and/or release notes to cover that case
3. include examples.

Thanks.

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.