How to export table data to text file with SELECT INTO OUTFILE statement?

To export MySQL table data to text file, MySQL provides SELECT INTO OUTFILE statement. It’s used when anyone wants to direct query output to a file. You can use this for your purpose. Take the following example:

SELECT * INTO OUTFILE "C:\\export_data_to_txt_file.txt"
      FIELDS TERMINATED BY '\t'
      LINES TERMINATED BY '\n' 
FROM database_name.table_name;

Alternatively, you can run mysql command line client with the 'e' flag and redirect standard output to a file:

mysql> -e 'SELECT * FROM test;' > filename.txt;