Export Mysql Query Results as CSV File

by Naveenkumar 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';






Tagged in:

1527
like
0
dislike
0
mail
flag

You must LOGIN to add comments