ERROR 1172 (42000): Result consisted of more than one row

最新推荐文章于 2025-05-26 17:08:36 发布

原创最新推荐文章于 2025-05-26 17:08:36 发布 · 2.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL

摘录所见所闻专栏收录该内容

27 篇文章

订阅专栏

本文对比了MySQL中使用INTO DUMPFILE与INTO OUTFILE导出数据的区别。INTO DUMPFILE仅导出单行记录，适用于BLOB类型数据存储；而INTO OUTFILE可以导出多行记录，并支持字段终止符、包围符及行终止符等选项。

mysql> select * from player_deposit_log where logTime > '2014-11-06 00:00:00' into dumpfile '/home/bjadmin/dev_super/player_deposit_log.bak';

ERROR 1172 (42000): Result consisted of more than one row

官方解释：If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file.

使用into dumpfile导出一行

mysql> select * from player_deposit_log where logTime > '2014-11-06 00:00:00'limit 1 into dumpfile '/home/bjadmin/dev_super/player_deposit_log.bak';
Query OK, 1 row affected (0.00 sec)

使用into outfile导出多行

mysql> select * from player_deposit_log where logTime > '2014-11-06 00:00:00' into outfile '/home/bjadmin/dev_super/player_deposit_log.bak'
-> fields terminated by ','
-> optionally enclosed by '"'
-> lines terminated by '\n'
-> ;
Query OK, 5 rows affected (0.01 sec)