注册

Mysql8迁移的时报不支持的接口或功能,有dateieme类型数据都报错

lyw 2022/07/15 1477 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm7
【操作系统】:win11
【CPU】: i5-11400
【问题描述】*:mysql8用DM迁移工具的时候,报以下错误,发现只要列是datetime格式且表里有数据时候迁移就会报这个
企业微信截图_16578655395441.png
mysql的表结构如下
INSERT INTO st-tods.sys_dict (id, value, label, type, description, sort, parent_id, create_by, create_date, update_by, update_date, remarks, del_flag) VALUES (‘1’, ‘1’, ‘NX-NY线路保护区内搭有简易棚子’, ‘unsafe_category’, ‘隐患类别’, 1, ‘0’, ‘1’, ‘2021-12-13 14:52:02’, ‘1’, ‘2021-12-13 14:52:39’, NULL, ‘0’);

CREATE TABLE st-tods.sys_dict (
id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘编号’,
value varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘数据值’,
label varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘标签名’,
type varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘类型’,
description varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘描述’,
sort decimal(10, 0) NOT NULL COMMENT ‘排序(升序)’,
parent_id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘0’ COMMENT ‘父级编号’,
create_by varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘创建者’,
create_date datetime NOT NULL COMMENT ‘创建时间’,
update_by varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘更新者’,
update_date datetime NOT NULL COMMENT ‘更新时间’,
remarks varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘备注信息’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记’,
PRIMARY KEY (id) USING BTREE,

回答 0
暂无回答
扫一扫
联系客服