Re: VALUES deprecation on INSERT since 8.0.19
I have tried to do without the Values() call and to reproduce like in the manual. But I do not get it to work.
Could you please look at the following example and write as it is correct?
I know it doesn't work that way, but I don't know what to do.
INSERT INTO articles ( id, appId, title ) (
SELECT
a.id,
a.appId,
a.title
FROM
articles_pre a
INNER JOIN cards_pre c ON a.id = c.artIdRef
WHERE
c.collectionIdRef = 3827
AND c.contentType = 'article'
) AS new
ON DUPLICATE KEY UPDATE title = new.title;
Subject
Views
Written By
Posted
1018
July 14, 2020 06:08AM
398
July 14, 2020 09:50AM
374
July 14, 2020 01:11PM
403
July 14, 2020 01:51PM
Re: VALUES deprecation on INSERT since 8.0.19
385
July 15, 2020 01:05AM
366
July 15, 2020 10:19AM
470
July 16, 2020 05:13AM
439
July 16, 2020 11:04AM
425
July 16, 2020 10:49PM
369
July 17, 2020 10:41AM
365
July 17, 2020 11:37AM
370
July 17, 2020 12:20PM
396
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.