SQL result -> File

There is a nice article about how to issue an sql and put the result in a file.
Basically its something like:

mysql> select emp_id, emp_name from emps into outfile 'c:/test.txt';
Query OK, 4 rows affected (0.03 sec)

http://gilfster.blogspot.com/2005/11/writing-sql-results-to-file.html