MySQL spool output

If you need to output the result of query, you have to do the following.

 

mysql > tee output.text;

mysql > select * from employees;

mysql > notee;