oh,yes.
There is a blob column in mytable.So i use "dumpfile" instead of "outfile".
There are more than 100 rows in mytable.
The follow sql is successful: select * into dumpfile '/home/wangxu/test4.data'
from mytable where id=1 or id=2;
Why it is false that select all rows in mytable?
> ----- Original Message -----
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
> Sent: Wednesday, April 11, 2007 10:45 AM
> Subject: Re: dumpfile question
>
>
>> 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 OUTFILE, MySQL writes only
>> one row into the file, without any column or line termination and
>> without performing any escape processing. This is useful if you want
>> to store a BLOB value in a file.
>>
>> http://dev.mysql.com/doc/refman/5.0/en/select.html
>>
>>
>> --
>> Paul DuBois, MySQL Documentation Team
>> Madison, Wisconsin, USA
>> MySQL AB, www.mysql.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>