MySQL Forums
Forum List  »  Stored Procedures

Re: VALUES deprecation on INSERT since 8.0.19
Posted by: Stephan Woods
Date: July 15, 2020 01:05AM

I have tried to do without the Values() call and to reproduce like in the manual. But I do not get it to work.

Could you please look at the following example and write as it is correct?
I know it doesn't work that way, but I don't know what to do.

INSERT INTO articles ( id, appId, title ) (
SELECT
a.id,
a.appId,
a.title
FROM
articles_pre a
INNER JOIN cards_pre c ON a.id = c.artIdRef
WHERE
c.collectionIdRef = 3827
AND c.contentType = 'article'
) AS new
ON DUPLICATE KEY UPDATE title = new.title;

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.