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