« Replace mPlayer with Xine for the default Video player in MythTV | Main | Samsung LCD TV xorg.conf settings »

How to export MYSQL to CSV

Simply execute

SELECT <fields or *> INTO OUTFILE '/tmp/result.text'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM <table> WHERE <condition>

Posted by Doug on August 2, 2006 7:14 PM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)