MySQL quick export as an Excel file

Test environment: Windows XP, MySQL 5.0.18, MySQL code gb2312

Use the OUTFILE method:

Select column name from table name into OUTFILE 'd:/text.xls ';

If garbled characters exist, try the following methods:
(From http://bjiokn.blog.51cto.com/1021758/390158, not tested)

 

Select convert (column name 1 using gb2312), convert (column name 2 using gb2312) into OUTFILE 'C:/xlstt12.xls 'from table name ;,

 

Because the default encoding method of Excel is gb2312, after the queried field is converted to db2312, both parties reach an agreement, so no garbled characters are involved.

At the same time, you can use the OUTFILE method to output the table in TXT format.

For example:

Select * from T3 into OUTFILE 'd:/1234.txt ';/* Save As a TXT file */