Shulou(Shulou.com)06/01 Report--

How to export mysql database tables to excel? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The method of exporting mysql database table to excel: first open [bestlovesky.xls] as text, then save as, select ansi encoding in encoding, and finally save it.

Methods for exporting mysql database tables to excel:

Method one

Use mysql commands and shell

Select * into outfile'. / bestlovesky.xls' from bestlovesky where 1 order by id desc limit 0,50

Method two

Open bestlovesky.xls as text, then save as, select ansi Encoding in Encoding, Save

Echo "select id,name from bestlovesky where 1 order by id desc limit 0,50;" | / usr/local/mysql/bin/mysql-h227.0.0.1-uroot-p123456 > / data/bestlovesky.xls

Method three

Use the mysql command

Mysql-uroot-p-e "select * from test.table2" > d:a.xsl Thank you for reading! After reading the above, do you have a general idea of how to export mysql database tables to excel? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.