Mysql using SELECT INTO outfile

MySQL supports the default syntax for querying results everywhere

Select: From table to outfile "Filepath\filename.txt";

If you encounter Error 1290 in the process of execution

or set this in the system variable, you need to enter into the Mysql.ini to use this variable, and restart the MySQL service to support this feature.

FilePath defaults to a subfolder of the database in the MySQL data directory on the server, such as:

C:\ProgramData\MySQL\MySQL Server 5.7\data\{your Database name}

　　

The file format can support TXT, CSV, and so on.

But a bad thing is, the result is that it contains only data and does not contain a table header. If a table header is required, it needs to be added by means of a union row of header rows before the result.

http://blog.itpub.net/26230597/viewspace-1226728/

Mysql using SELECT INTO outfile