MySQL Forums
Forum List  »  Stored Procedures

Re: VALUES deprecation on INSERT since 8.0.19
Posted by: Peter Brawley
Date: July 16, 2020 11:04AM

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.

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.