[Mysql] export a Mysql table to Excel

[Mysql] export a Mysql table to Excel

Exporting a Mysql table to Excel is not as difficult as importing an Excel table to one of the Mysql tables (click to open the link,

Enter the following T-SQL statement directly:

Select * from a table into outfile 'file Path'

For example, I want to export an I _studenttable of the following testdata Library to the 1.xls directory of the D-root directory:

Use test

Then, enter:

Select * from I _student into outfile 'd:/1.xls'

For example:

Then you will find a 1.xls waiting for you on the dashboard. Of course, the following information may be prompted when you open it:

You can find that the content of 1.xls is as follows without the header id and name, but it is enough to query the content.

To promote any query content, you only need to modify the previous Export Statement.