Often we want to store the results given by Mysql command line into some text file. As usual google helped me to find the way.

before running any command, just run this command.

mysql> \T /home/hari/result.txt

in windows

mysql> \T c:\result.txt

The file name and path can be anything of your choice, but it should be writable by you.