Windows导出Mysql查询的数据Excel文件select * into outfile '文件路径' from

SELECT f_id,f_accountNum,f_addr into outfile ‘E://t1.xlsx‘ FROM tb_sg186info WHERE f_id >= 1 AND f_id <= 500000;
SELECT f_id,f_accountNum,f_addr into outfile ‘E://t2.xlsx‘ FROM tb_sg186info WHERE f_id >= 500001 AND f_id <= 1000000;
SELECT f_id,f_accountNum,f_addr into outfile ‘E://t3.xlsx‘ FROM tb_sg186info WHERE f_id >= 1000001 AND f_id <= 1500000;
SELECT f_id,f_accountNum,f_addr into outfile ‘E://t4.xlsx‘ FROM tb_sg186info WHERE f_id >= 1500001 ;

SELECT f_id,f_accountNum,f_addr into outfile ‘E://t1.xlsx‘ FIELDS TERMINATED BY ‘ ‘ FROM tb_sg186info WHERE f_id >= 1 AND f_id <= 500000;