no, please use "load data infile" function. ----- Original Message ----- From: "Wm Mussatto" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> 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 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 >> > Related question. does mysqldump properly escape blobs so that they can be > restored via 'mysql -u xxx -p databaseName < dumpFile' ? > > ------ > William R. Mussatto > Systems Engineer > http://www.csz.com > 909-920-9154 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >