From: Johan De Meersman Date: June 26 2009 9:43am Subject: Re: How can we stock the query result into a text file List-Archive: http://lists.mysql.com/mysql/217970 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=001636c5b9e80597ee046d3d2b5b --001636c5b9e80597ee046d3d2b5b Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Have a look at "create table as select" and the csv engine. On Thu, Jun 25, 2009 at 4:18 PM, Lin Chun wrote: > Hi > > In mysql , how can we stock the query result into a text file > > the table is too large , i don't want to dump it , but select a part of it, > i wrote a script perl to do this, but each time i have to change the > parameters in the script to get another table, when i google it, i find the > function in Oracle > > " > spool 'filenameandpath.txt' > > select ... > from .. > / > > spool off > " > does Mysql has such function? > > > > > -- > ------------------------- > Lin Chun > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED. --001636c5b9e80597ee046d3d2b5b--