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"
fields terminated by ',' enclosed by '"'
lines terminated by '\n'
from tableout;
This should give you a file with each field enclosed with quotes and
separated by commas, with each row delimited by a \n:
"col1row1","col2row1","col3row1","col4row1","col5row1"
"col1row2","col2row2","col3row2","col4row2","col5row2"
"col1row3","col2row3","col3row3","col4row3","col5row3"
See the manual:
http://www.mysql.com/doc/S/E/SELECT.html
On Thu, 25 Jan 2001, Scott Baker wrote:
> 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?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
