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

This article will explain in detail how to derive data structures from navicat. 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.

1. First, find the database where you want to export the data structure, as shown in the figure.

2. Then right-click the database, and note that you want to select "data transfer" instead of "dump SQL file", as shown in the figure.

3. After entering the data transfer settings, select the Advanced settings, as shown in the figure.

4. After entering the advanced settings, uncheck the box before "insert record". If you don't remove it, the exported data structure will also contain data records, as shown in the figure.

5. Then go back to the general settings, select "File" for the target, and select the target path for the data structure file to store, as shown in the figure.

6. Sql format can be selected according to the version of mysql you use, such as "mysql4.0", and then click "start" below, as shown in the figure.

7. Then output the log information of the data structure dump, and successfully will appear after success, as shown in the figure.

8. Then go to the destination path to open the dumped sql file, and you can see that the data structure has been successfully dumped, and it contains only the data structure, but no data record, as shown in the figure.

On how to export the data structure of navicat 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.