load data 报错" truncated for column..... at row 1"

使用load data 导入数据时报错 truncated for column 'id' at row 1，解决办法： 

show variables like '%sql_mode%';

 

set sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

 

load data infile ...;