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]
