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.
t2 has more fields than t1, so the import fails.
Read More:
- [Solved] Mysql Error: [Err] 1136 – Column count doesn‘t match value count at row 1
- Solve ERROR 1136 (21S01) in Mysql: Column count doesn’t match value count at row 1
- Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
- ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
- SQL Server Group sort de duplication row_ number() over ( PARTITION BY t1.col_ 2 ORDER BY 1 )
- Mybatis Add Datas error: ERROR: Field * doesn‘t have a default value
- [Solved] MySQL Error: Can‘t find record in ‘order_form‘
- How to Solve Mysql8 load data error
- [Solved] com.mysql.jdbc.MysqlDataTruncation: Data truncation xxxx
- MYSQL Error: Can‘t find error-message file [How to Solve]
- [Solved] mysqldump Command Error: Got error: 2002: “Can‘t connect to server on ‘127.0.0.1‘ (36)“ when trying to connect
- How to release Oracle PLSQL data lock table
- [Solved] mysqldump: Got error: 1556: “You can‘t use locks with log tables.“ when using LOCK TABLES
- Linux Error: [ERROR] –initialize specified but the data directory has files in it. Aborting.
- [Solved] no all patern found! & Error on Generate Activation Code…
- Mongoose: How to delete all documents in collection
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘