Re: export data from mysql into a text file or CSV file

[Gaurav Khambhala]

For given query:

SELECT name,lastname,age FROM profile

The query returns three columns of the mysql table. Now for redirecting/print into a file:

SELECT name,lastname,age FROM profile INTO OUTFILE '/tmp/userdata.txt'

This will output data into the passed file in the above statement.

To output data in terms of CSV format add more options to the query as following:

SELECT name,lastname,age FROM profile INTO OUTFILE '/tmp/userdata.txt' FIELDS enclosed by '"' separated by "," LINES TERMINATED BY '\n'


Regards,
Gaurav Khambhala



Edited 1 time(s). Last edit at 10/09/2009 05:02AM by Gaurav Khambhala.