Export MySQL Table to a CSV File

SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv' 
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';