MySQL Export data dictionary using Navicat

This is a little trick.

Use MySQL of the Information_schema in the COLUMNS Table

and the Navicat Quick Export Data dictionary with export function in

create temporarytable  ' COLUMNS '   (   ' table_catalog '  varchar (+)  NOT  Null default ',   ' Table_schema '  varchar (+)  not null default ',   ' table_name '  varchar ( NOT NULL DEFAULT  ',   ' column_name '  varchar (  not null default ',   ' ordinal_position '  bigint (+)  unsigned  notnull default  ' 0 ',   ' column_default '  longtext,   ' is_nullable '   varchar (3)  NOT NULL DEFAULT  ',   ' data_type '  varchar ( not null)  DEFAULT  ',   ' character_maximum_length '  bigint (+) Unsigned default null,    ' Character_octet_length '  bigint (+)  unsignedDEFAULT NULL,   ' Numeric_ PRECISION '  bigint (+)  unsignedDEFAULT NULL,   ' Numeric_scale '  bigint (+)   Unsigned defaultnull, &nbSP; ' datetime_precision '  bigint (+)  unsignedDEFAULT NULL,   ' character_set_name '   varchar  DEFAULTNULL,   ' collation_name '  varchar (+)  DEFAULT NULL,   ' Column_type '  longtext NOT NULL,   ' Column_key '  varchar (3)  not null  DEFAULT  ',   ' EXTRA '  varchar (+)  NOT NULL DEFAULT  ',    ' privileges '  varchar  NOT NULL DEFAULT  ',   ' column_comment '   varchar (1024x768)  NOT NULLDEFAULT  ')  ENGINE=MyISAMDEFAULT CHARSET=utf8;

For example I need to export Guifan Libraries and Test Data dictionary information for the library:

Select Table_schema,table_name,column_type,column_comment frominformation_schema.columns where TABLE_SCHEMA= ' Guifan ' or table_schema= ' test '

650) this.width=650; "title=" 1.JPG "alt=" wkiom1djm9gdvwtoaagjz0iv4yc776.jpg-wh_50 "src=" Http://s1.51cto.com/wyfs02 /m01/82/e1/wkiom1djm9gdvwtoaagjz0iv4yc776.jpg-wh_500x0-wm_3-wmp_4-s_3367296582.jpg "/>

Follow the instructions to export

OK, this is the data dictionary I want.

650) this.width=650; "title=" 2.JPG "alt=" wkiol1djnpsimbjbaagknxxbevc728.jpg-wh_50 "src=" Http://s4.51cto.com/wyfs02 /m01/82/e0/wkiol1djnpsimbjbaagknxxbevc728.jpg-wh_500x0-wm_3-wmp_4-s_1284143166.jpg "/>

This article is from the "Age volt" blog, please make sure to keep this source http://suifu.blog.51cto.com/9167728/1790306

MySQL Export data dictionary using Navicat