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
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