SELECT
*
INTO
OUTFILE
'C:\\my_excel_table.csv'
FIELDS TERMINATED
BY
','
OPTIONALLY ENCLOSED
BY
'"'
LINES TERMINATED
BY
'\r\n'
FROM
mytable;
SELECT
*
INTO
OUTFILE
'C:\\my_excel_table.csv'
FIELDS TERMINATED
BY
','
OPTIONALLY ENCLOSED
BY
'"'
LINES TERMINATED
BY
'\r\n'
FROM
mytable;