Re: VALUES deprecation on INSERT since 8.0.19

[Peter Brawley]

Quote

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

1 There is no column named `app`

2 collId is not defined

3 To Insert specifying just some columns, you need to specify the columns, otherwise MySQL complains "Column count doesn't match value".

When these somewhat careless errors are corrected, the Insert works in 8.0.21 with the warning avout this use of Values() being deprecated.