使用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 ...;
使用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 ...;