Re: VALUES deprecation on INSERT since 8.0.19
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.
Subject
Views
Written By
Posted
1231
July 14, 2020 06:08AM
507
July 14, 2020 09:50AM
466
July 14, 2020 01:11PM
485
July 14, 2020 01:51PM
456
July 15, 2020 01:05AM
460
July 15, 2020 10:19AM
556
July 16, 2020 05:13AM
Re: VALUES deprecation on INSERT since 8.0.19
538
July 16, 2020 11:04AM
508
July 16, 2020 10:49PM
482
July 17, 2020 10:41AM
445
July 17, 2020 11:37AM
491
July 17, 2020 12:20PM
480
July 21, 2020 06:04AM
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.