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]
