Mysql exports the queried data as excel and mysqlexcel

Mysql exports the queried data as excel and mysqlexcel

Now you need to export some data from the mysql database to excel and print it. In fact, it is very easy to implement the above requirements, as long as you write the SQL statement, and then export it as excel

The specific implementation process is as follows:

1. Write an SQL statement and query the result.

2. Right-click the query result and select export all table data records/result ..."

:

Select export all table data records/result as..., as shown in

Click Export.

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

Note that it is better to use the field following the select statement as Chinese characters. In this case, the table title is a Chinese character.

Mysql automatically converts the queried data to excel.

SELECT * into outfile './test.xls' FROM tb1 WHERE 1 order by id DESC;

Mysql automatically converts the queried data to excel.

SELECT * into outfile './test.xls' FROM tb1 WHERE 1 order by id DESC;