Tag Archives: 1. MySQL learning

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

1. Error Messages:

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
2. Reason
t2 has more fields than t1, so the import fails.