Quickly generate a database dictionary using Navicat

Refer to Address: 60764420

Reprint declaration Address: http://blog.itpub.net/15498/viewspace-2134152

Here's how:
Use the Columns table information in MySQL's Information_schema library to implement
For example, you need to export the data dictionary information for the IXINNUO_ZXPT library:
Open Navicat, select query-new query:

Select Table_schema as ' database ', table_name as ' table name ', column_name as ' field name ', Column_type as ' data type ', EXTRA as ' PK ', column_commen T as ' field description ' from Information_schema.columns where table_schema= ' sale_security '

In the top-right corner of the query results page, you can see a button that has an export function, click to select a variety of export formats, such as export to Excel, you can select the Excel file (2007 or later),
Then follow the instructions step by step next to export, as shown in:







The resulting Excel content is as follows:

Quickly generate a database dictionary using Navicat