从低版本的MySQL导出的文件在MySQL8中执行导入,出现 [error]1067 - Invalid default value for 'CreateDateTime',
先通过设置mysql_mode
进入数据库中执行:
-- ----------------------------
-- execute sql
-- ----------------------------
show variables like ‘sql_mode’;
-- ----------------------------
-- show data
-- ----------------------------
ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
-- ----------------------------
-- set sql_mode,remove NO_ZERO_IN_DATE,NO_ZERO_DATE
-- ----------------------------
sql_mode=’ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;
移除了对时间为零的规则,但是仍然报错[error]1067 - Invalid default value for 'CreateDateTime':