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

This article mainly introduces how to use navicat to derive the data dictionary, the article is very detailed, has a certain reference value, interested friends must read it!

The methods are as follows:

It is realized by using the COLUMNS table information in the information_schema library of mysql.

For example, you need to export the data dictionary information of the ixinnuo_ zxpt library:

Open Navicat and 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 results page, you can see a button with the export feature. Click to select a variety of export formats, such as exporting to Excel, then you can select the Excel file (version 2007 or above), and then follow the prompts to export Next step by step, as shown in the following figure:

The resulting Excel is as follows:

The above is all the contents of the article "how to Export data Dictionary with navicat". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.