> Is there a way to export the results to a text file (comma-delimited
> preferred)...
>
> ie, SELECT * FROM TABLE >> test.txt ; (obviously this doesn't work) :)
With our database developer tool that includes support for MySQL,
this is an easy task.
Check it out, Database Workbench: www.upsce
try :
select . into outfile '/tmp/t3.csv' FIELDS TERMINATED BY ',' LINES
TERMINATED BY '\n' from table where .
This will create a file in the /tmp directory on the DB server itself
this doesn't do the column headings and your output file cannot already
exist.
-Original Mess
