Have a look at "create table as select" and the csv engine. On Thu, Jun 25, 2009 at 4:18 PM, Lin Chun <franks1...@gmail.com> 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.
