Re: dumpfile question

2007-04-11 Thread wangxu
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

Re: dumpfile question

2007-04-11 Thread Wm Mussatto
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

Re: dumpfile question

2007-04-10 Thread Paul DuBois
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