How to export data dictionary using navicat

The method is as follows:
Use the COLUMNS table information in the information_schema library of mysql to achieve this.
For example, you need to export the data dictionary information of the ixinnuo_zxpt library:
Open Navicat, select query-->New query:

select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where 
TABLE_SCHEMA='ixinnuo_zxpt'

In the upper right corner of the query result page, you can see An export function button, click to select multiple export formats, such as exporting to Excel, then you can select the Excel file (2007 or above), and then follow the prompts to export step by step, as shown in the following figure:

Related recommendations: "Navicat for mysql graphic tutorial"

##The final generated Excel content is as follows:

The above is the detailed content of How to export data dictionary using navicat. For more information, please follow other related articles on the PHP Chinese website!