Re: Export to CSV

[Mike Hillyer]

All you need is to do the following:

SELECT a,b,a+b INTO OUTFILE '/tmp/result.text'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

And the results are sent to /tmp/result.text in CSV format.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]
Mobile: [phone]
Blog: http://www.openwin.org/mike