Export Mysql Query Results as CSV File
by Naveenkumar[ Edit ] 2014-03-15 18:13:22
Export Mysql Query Results as CSV File By using the following Query
SELECT field1,field2,field3 FROM table1 INTO OUTFILE '/home/user/filename.csv' FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\n';
