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?
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.txt"
th/to/file' from ...
Regards
Quentin
-Original Message-
From: Jason Terry [mailto:[EMAIL PROTECTED]]
Sent: Friday, 26 January 2001 10:54
To: [EMAIL PROTECTED]
Subject: How do I make a CSV dump
Anybody have a quick way to make a CSV dump of a SELECT?
If MySQL can't do it directly is the