mysql 如何输入 select_mysql的select结果输入到文件

mysql> select count(1) from xcdqm_store_purchase_total_amount_streaming into outfile ‘/tmp/xcdqm_store_purchase_total_amount_streaming.count‘

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

mysql> show variables like ‘%secure%‘;

+------------------+-----------------------+

| Variable_name | Value |

+------------------+-----------------------+

| secure_auth | ON |

| secure_file_priv | /var/lib/mysql-files/ |

+------------------+-----------------------+

2 rows in set (0.00 sec)

说明 mysql因为权限问题，只能写数据到 /var/lib/mysql-files/ 路径

select count(1) from xcdqm_store_purchase_total_amount_streaming into outfile ‘/var/lib/mysql-files/xcdqm_store_purchase_total_amount_streaming.count‘

执行成功后，即可在 /var/lib/mysql-files/ 目录下查看到对应的文件

[[email protected] ~]# cd /var/lib/mysql-files/

[[email protected] mysql-files]# ll

total 4

-rw-rw-rw- 1 mysql mysql 2 Dec 28 14:32 xcdqm_store_purchase_total_amount_streaming.count

[[email protected] mysql-files]# cat xcdqm_store_purchase_total_amount_streaming.count

2

原文：https://www.cnblogs.com/wooluwalker/p/12111617.html