MySQL Forums
Forum List  »  Stored Procedures

Re: VALUES deprecation on INSERT since 8.0.19
Posted by: Stephan Woods
Date: July 16, 2020 05:13AM

ok thank you

Here the needed tables and some example entries


CREATE TABLE `articles` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`appId` int unsigned DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`shortTitle` varchar(255) DEFAULT NULL,
`byline` varchar(1024) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`artTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='\r\n';

CREATE TABLE `articles_pre` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`appId` int unsigned DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`shortTitle` varchar(255) DEFAULT NULL,
`byline` varchar(1024) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`artTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='\r\n';


CREATE TABLE `cards_pre` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`collectionIdRef` int unsigned NOT NULL,
`name` varchar(65) DEFAULT NULL,
`contentType` enum('collection','article','banner') DEFAULT 'article',
`title` varchar(255) DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`artIdRef` int unsigned DEFAULT NULL,
`crdTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `artIdRef` (`artIdRef`),
CONSTRAINT `cards_pre_ibfk_1` FOREIGN KEY (`artIdRef`) REFERENCES `articles_pre` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;


INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (1, 1, 'Knows 01(free)', NULL, NULL, NULL, '2019-11-19 15:29:40');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (2, 1, 'Knows 02 (free)', NULL, NULL, NULL, '2019-03-26 15:01:45');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (3, 1, 'Knows 03 (restricted)', NULL, NULL, NULL, '2019-03-20 16:35:39');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (4, 1, 'Knows 04 (restricted)', NULL, NULL, NULL, '2019-03-20 16:35:53');


INSERT INTO `articles`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (1, 1, 'Knows 01(free)', NULL, NULL, NULL, '2019-11-19 15:29:40');
INSERT INTO `articles`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (2, 1, 'Knows 02 (free)', NULL, NULL, NULL, '2019-03-26 15:01:45');


INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (1, 1134, 'Art1', 'article', 'Art1', NULL, 1, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (2, 1134, 'Art2', 'article', 'Art2', NULL, 2, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (3, 1134, 'Art3', 'article', 'Art3', NULL, 3, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (4, 1134, 'Art4', 'article', 'Art4', NULL, 4, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (5, 1135, 'Art3', 'article', 'Art3', NULL, 3, '2018-11-30 16:52:28');

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.