Re: VALUES deprecation on INSERT since 8.0.19

[Stephan Woods]

Sry, here corrected for the DTD and Inserts:

(collectionIdRef comes from the procedure in the example case its 1134)

INSERT INTO articles
(SELECT
a.id,
a.appId,
a.title,
a.shortTitle,
a.byline,
a.author,
a.artTimestamp
FROM articles_pre a
INNER JOIN cards_pre c ON a.id = c.artIdRef
WHERE
c.collectionIdRef = 1134 # var given to procedure
AND c.contentType = 'article'
)
ON DUPLICATE KEY UPDATE
title = VALUES ( title );