A statement homemade data dictionary

If some children's shoes have the need to make a data dictionary to Excel, refer to the SQL I provided.

SELECT TABLE_SCHEMA database name, TABLE_NAME table name, column_name field name, Column_type field type, is_nullable nullable, column_default default, case when column_key= ' PRI ' then ' primary key ' when column_key= ' MUL ' then ' normal index ' ELSE ' None ' END index information, column_comment comment from INFORMATION_SC Hema. Columnswhere table_schema (' MySQL ', ' information_schema ', ' Performance_schema ') ORDER by table_name

Shown below

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5A/36/wKioL1T6oazxaaSYAARKG-orzOM798.jpg "title=" Baidushurufa_2015-3-7_14-53-48.png "alt=" Wkiol1t6oazxaasyaarkg-orzom798.jpg "/>

You can export the result set to Excel, which can be used as a data dictionary for proper processing.

This article is from the "original" blog, please be sure to keep this source http://imysqldba.blog.51cto.com/1222376/1618242

A statement homemade data dictionary