ERROR 1261 (01000): Row 1 doesn‘t contain data for all columns

一  问题描述
MariaDB [baidd]> select * from t1  into outfile '/var/lib/mysql/t1.txt'; Query OK, 1 row affected (0.000 sec
MariaDB [baidd]>  load data infile '/var/lib/mysql/t1.txt' into table t2; ERROR 1261 (01000): Row 1 doesn't contain data for all columns
二 出错原因
t2的字段比t1字段多，因此导入失败。

ERROR 1261 (01000): Row 1 doesn‘t contain data for all columns最先出现在Python成神之路。