为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm7
【操作系统】:win11
【CPU】: i5-11400
【问题描述】*:mysql8用DM迁移工具的时候,报以下错误,发现只要列是datetime格式且表里有数据时候迁移就会报这个
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,
在迁移时指定mysql的驱动
