MySQL5.7导入数据报错ERROR 1067 (42000) at line 1015: Invalid default value for 'service_time' 解决办法：

修改my.cnf,

[mysqld] 下面添加

sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION