Databases are often used in daily software development work, and the data structure of sql often needs to be exported. Generally, everyone can operate the dump sql file through Navicat, but the dump sql file will contain Containing data does not only contain data structures. So how does Navicat export the data structure? This article will introduce it below.
Recommended tutorial: navicat graphic tutorial
1. First, find the database where you want to export the data structure, such as As shown in the figure.
#2. Then right-click the database. Note that you must select "Data Transfer" instead of "Dump SQL File", as shown in the figure.
#3. After entering the data transmission settings, select the "Advanced" settings, as shown in the figure.
4. After entering the advanced settings, remove the check in front of "Insert Record". If not removed, the exported data structure will still contain data records, as shown in the figure. .
#5. Then return to the general settings, select "File" as the target, and select the target path where the data structure file is to be stored, as shown in the figure.
#6. The sql format can be selected according to the version of mysql you are using, for example, select "mysql4.0", and then click "Start" below, as shown in the figure Show.
#7. Then the log information of the data structure dump will be output. Successfully will appear after success, as shown in the figure.
8. Then go to the target path and open the dumped sql file. You can see that the data structure has been dumped successfully, and it only contains the data structure and no data records. as the picture shows.
The above is the detailed content of How to export data structure in navicat. For more information, please follow other related articles on the PHP Chinese website!