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;