Mysql database exports excel xml and other format files

mysql database exports files in various formats

1. Open the mysql client tool SQLyog

2. Open the database where the table is located, find the table where you want to export the file, and focus the mouse on this table

3. Right click-----》Export--- ->Export Table Data As CVS,....

#4. The first arrow is to select the file format to be exported. If we want to export excel format, then we choose excel xml. The second arrow is the path to export the file

##5. I want to explain here that many people are confused, What I want to export is an excel file, but in the end it is still an xml format file. What is going on? Here I want to explain. We still need to convert it once, convert the xml format file into an excel file, and open the office excel file.

##6. Find the exported file ddd. xml, and then use the mouse to drag it into the excel file

##7. Find the exported file ddd.xml, and then use Drag the mouse into the excel file

##8 .Then select the excel format file format to save, click Save

##

The above is the detailed content of Mysql database exports excel xml and other format files. For more information, please follow other related articles on the PHP Chinese website!