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=arch...@jab.org
