mysqldump --tab=/tmp --no-create-info --fields-terminated-by=',' database
table
Should do the trick. This will create a file called /tmp/table.txt,
containing the data. Use --where=".." to select from fields.
For more complext selects, look at
select field1, field2 into outfile '/path/to/file'
As will the urSQL Utility (MS Windows):
http://www.urbanresearch.com/ursql
urSQL can export query results in a variety of formats:
-> HTML
-> CSV
-> Excel
-> Word
-> Text
Depending on your data, you might also be able to use the SELECT INTO
OUTFILE syntax:
select * into outfile "tableout.tx
If you're running windows go to
my.anse.de his client will do it.
Scott
At 02:54 PM 1/25/2001 -0700, Jason Terry wrote:
>Anybody have a quick way to make a CSV dump of a SELECT?
>
>If MySQL can't do it directly is there an easy way in PERL?
>
>
>-
