command to spool query output to another log file in MySQL

 Spooling  SQL query Output in a File in MySQL & MariaDB

mysql> use testdb;

Database changed

mysql> tee testspool.txt;

Logging to file 'testspool.txt;'

mysql> select name from emp;

mysql> notee

Outfile disabled.