tfile '/path/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
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?
>
>
>-
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?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
