Login mysql client. Do the following commands. tee ie.txt; ... notee; On Thu, Jun 25, 2009 at 10:29 PM, John Daisley < john.dais...@mypostoffice.co.uk> wrote:
> SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus > > SELECT columnname from tablename into outfile '/path/and/filename.txt' > > Regards > > John > > > > 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 > > > > > > ______________________________________________ > > This email has been scanned by Netintelligence > > http://www.netintelligence.com/email > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com > > -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn