Building a comma delimited file from ...

[ruthc]

Does anyone have an example or know where I can find an example of how to build a comma delimited file from an SQL statement. I want to build a file using MySQL to download into Excel. Thanks.

[sepodati]

SELECT * INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ',' FROM your_table;

Use an absolute path for data.txt if you want to make sure you know where to find it...

---John Holmes...

[ruthc]

Thanks. I appreciate the help.