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

This article will explain in detail the method of exporting tables with mysql tools. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Export method: 1, use mysql's navicat tool to enter the source database system; 2, find the corresponding database table; 3, click "Export Wizard"; 4, select the export format; 5, select the location of the export file; 6, select the export column; 7, check the "include column title"; 8, start the export operation and wait for the export to be completed.

The method of exporting database table data by using mysql tool

Tools:

Navicat for mysql

Source database table (here is an example using rights)

Target database table (webrights is used as an example here)

Steps:

1. First of all, open the database tool, mysql's visualization tool navicat for mysql tool.

Enter into the source database system.

2. Find the corresponding database table and you should be able to see the following interface. I believe that the interface should be similar, but it is true that the content is different.

3. Click "Export Wizard" in the menu bar in the upper left corner. Yes, that's it.

After clicking, you will see the following pop-up box.

4. Click the button "Yes" to proceed to the next step, and the system will pop up the following interface.

If you click the button [No], then you have to do it again.

5. Here, the system is exported to txt format by default, and you can modify it according to your own needs.

The editor has not changed, because there is an option of txt to import at the time of import.

Click next and this window will come out.

6. Here, you need to select the location of the exported file, as well as the target folder directory and file name.

Continue to click the next step.

Select the columns you want to export.

7. Click next after you have selected it. Note that it is best to check [include column headings] here.

As for why, it is convenient to import!

8. Click next to reach the following interface, where there is nothing to do.

9. Click start, and you will see the following results when you are finished.

Seeing success means that you have successfully exported the data!

On the method of exporting tables with mysql tools to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.