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

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)