MySQL exports the queried data to Excel

Now you need to export some data from the MySQL library to Excel and print it. In fact, implementation of the above-mentioned requirements is very simple, as long as you write out the SQL statement, and then exported as Excel can

The specific implementation process is as follows:

1, write the SQL statement, query the results.

2. Right-click on the results of the query and select "Export all table data Records/results to ..."

：

Select "Export all table data Records/Results to ..." appears as shown

Click Export.

========================================================

It is important to note that the field after the select is better with the as into Chinese characters, so the table title is the Chinese character.

MySQL exports the queried data to Excel