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;