>-Original Message-
>From: Moon's Father [mailto:yueliangdao0...@gmail.com]
>Sent: Friday, June 26, 2009 4:13 AM
>To: john.dais...@butterflysystems.co.uk
>Cc: Lin Chun; mysql@lists.mysql.com
>Subject: Re: How can we stock the query result into a text file
>
&
Have a look at "create table as select" and the csv engine.
On Thu, Jun 25, 2009 at 4:18 PM, Lin Chun wrote:
> Hi
>
> In mysql , how can we stock the query result into a text file
>
> the table is too large , i don't want to dump it , but select a part of it,
>
file '/path/and/filename.txt'
>
> Regards
>
> John
>
>
> > Hi
> >
> > In mysql , how can we stock the query result into a text file
> >
> > the table is too large , i don't want to dump it , but select a part of
> > it,
> > i wrote
SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
SELECT columnname from tablename into outfile '/path/and/filename.txt'
Regards
John
> Hi
>
> In mysql , how can we stock the query result into a text file
>
> the table is too large , i don't
Hi
In mysql , how can we stock the query result into a text file
the table is too large , i don't want to dump it , but select a part of it,
i wrote a script perl to do this, but each time i have to change the
parameters in the script to get another table, when i google it, i find the
fun
