将远程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 '\n' \
from globaldata.g_game\
where id4399 is null and isHomePage='1';

2.发送到本机

SQL>system sz idIsNull2.csv;