MySQL Forums
Forum List  »  Stored Procedures

Re: VALUES deprecation on INSERT since 8.0.19
Posted by: Stephan Woods
Date: July 16, 2020 10:49PM

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 );

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.