Output MySQL query result to .csv format (useful for large datasets)

mysql-output-csv.sql

-- This will save the the query result to /tmp/output.csv
SELECT
  *
FROM table
INTO OUTFILE '/tmp/output.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'