SELECT * INTO OUTFILE 'C:\\my_excel_table.csv'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'LINES TERMINATED BY '\r\n'FROM mytable;
Posted inGeneral
Mysql Query to Excel Export
SELECT * INTO OUTFILE 'C:\\my_excel_table.csv'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'LINES TERMINATED BY '\r\n'FROM mytable;