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;