Exporting MYSQL results into a external files
 

Hello,
Can anyone please tell me how to import the results of MYSQl query to a external file..I have tried

mysql> MYSQL query tee <external file>

but this does not work

Saravanan

try this:

mysql <myquery.sql >results.log

Also, try using the -B switch for actual usable results. This will write out the data as a tab-delimited data file instead of drawing the columns and tables.

cheers

All the above are fine but my requirement is to export the result f a mysql query into an external files say a text file or a Excel Sheet or a HTML file..I am able to import the query from an external file and execute them..using source <filename> but tee is not working for me..

mySQL redirecting query result to a .txt file!

Search for this in the software forum and your answer is found!