mysql sql_mode引发的报错

今天mysql在导入数据的时候，报错。查看官档是sql_mode引发的

 

load data infile 'd:/data/tmp_t1_20180416.csv' into table t1__20180416  fields terminated by '|'  optionally enclosed by '' lines terminated by '\n';

 

 

1.ERROR 1067 (42000): Invalid default value for 'update_time'

 

set sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

 

 

 

2.ERROR 1366 (HY000): Incorrect integer value: 'id' for column 'id' at row 1

 

set sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";