SELECT * INTO OUTFILE "c:/outputfile.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM tablename;