Haneef Puttur

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;

.

Exit mobile version