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


INSERT INTO articles
FROM articles_pre a
INNER JOIN cards_pre c ON = c.artIdRef
c.collectionIdRef = collId # var given to procedure
AND c.contentType = 'article'
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, you can't reply to this topic. It has been closed.

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.