ERROR 1261 (01000):Row 1 doesn't contain data for all colums

从CSV文件中导入数据到表中

mysql> load data  infile 'xxx.csv' into table Table fields terminated by '\t' lines terminated by '\n';

 

发生如下错误:

ERROR 1261 (01000):Row 1 doesn't contain data for all colums

 

这是因为sql_mode 被设为了 strict 模式, 要想继续导入需要把“strict_trans_tables” 从 sql_mode 中去掉.

 

查看 MySQL 当前连接的 sql_mode

mysql> show variables like 'sql_mode';

临时修改sql_mode

mysql> set sql_mode='';

 

转载于:https://my.oschina.net/u/1018607/blog/857728