How to save query results in a text file

Here's how to put MySQL query results in an ASCII file i.e. tab delimited or CSV file.

mysql> SELECT field1, field2 FROM tab1 INTO OUTFILE 'logfile.txt';

By default fields will be separated by tab, but you can change it using the following
command:

mysql> SELECT field1, field2 FROM tab1
       INTO OUTFILE 'logfile.txt'
       FIELDS TERMINATED BY ',' 
       ENCLOSED BY '"' 
       LINES TERMINATED BY '\n';