"MySQL" exports a table of MySQL to Excel

Exporting a MySQL table to Excel is not as difficult as "MySQL" Importing an Excel table into one of the MySQL tables (click to open the link).

Enter the following T-SQL statements directly:

SELECT * from a table into outfile ' file path '

For example, I want to export a i_student table of the test database below to 1.xls in the D packing directory:

Use test

After that, enter:

SELECT * from i_student to outfile ' D:/1.xls '

Such as:

Then you'll find a 1.xls in the D-disk waiting for you, of course, the following information may be prompted when opening:

Do not control it, direct election is, you can find the content of 1.xls, there is no header ID and name, but there is enough to query the content.

Similarly to any query content, only need to put the previous export statements, modify it.

"MySQL" exports a table of MySQL to Excel