将远程mysql服务器数据导出 csv 并发送到我的本机

1.在SQL上执行查询并导出操作

SQL> select gid,package_name,app_name 
into outfile 'idIsNull2.csv' character set gbk fields terminated by ',' optionally enclosed by '"' lines terminated by ' '
from globaldata.g_game
where id4399 is null and isHomePage='1';

2.发送到本机

SQL>system sz idIsNull2.csv;
原文地址:https://www.cnblogs.com/zhengwenqiang/p/8682162.html