Exporting Table Data in a File

SELECT * FROM table_name INTO OUTFILE 'C:/new_file.xls'

FIELDS TERMINATED BY ',' ENCLOSED BY '"'

LINES TERMINATED BY '\n';