no,
please use "load data infile" function.
- Original Message -
From: "Wm Mussatto" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 12, 2007 12:44 AM
Subject: Re: dumpfile question
> On Tue, April 10, 2007 19:45, Paul DuBois said:
>> At 10:15 AM +0800
On Tue, April 10, 2007 19:45, Paul DuBois said:
> At 10:15 AM +0800 4/11/07, wangxu wrote:
>>follow is my sql:
>>
>>
>>
>>select * into dumpfile '/home/wangxu/test4.data' from mytable ;
>>
>>
>>
>>
>>
>>mysql server report: Result consisted of more than one row
>>
>>
>>
>>why?how to use the "select
hat select all rows in mytable?
> - Original Message -
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>;
> Sent: Wednesday, April 11, 2007 10:45 AM
> Subject: Re: dumpfile question
>
>
>> At 10:15 AM +0800 4/11/07,
At 10:15 AM +0800 4/11/07, wangxu wrote:
follow is my sql:
select * into dumpfile '/home/wangxu/test4.data' from mytable ;
mysql server report: Result consisted of more than one row
why?how to use the "select into dumpfile"?
From the manual:
If you use INTO DUMPFILE instead of INTO
follow is my sql:
select * into dumpfile '/home/wangxu/test4.data' from mytable ;
mysql server report: Result consisted of more than one row
why?how to use the "select into dumpfile"?
