Re: VALUES deprecation on INSERT since 8.0.19

[Stephan Woods]

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;