Export MySQL table notes and field notes to do a data dictionary

Often check the data table do not know the meaning of the field, and then to look at the design table to see the meaning of the field, the database has been modified by many people, database design documents can not support the current table structure. Just want to make a data dictionary, MySQL in the INFORMATION_SCHEMA library has not known before, so it is very convenient to use.

Select Table_schema database name, TABLE_NAME table name, column_name column name, data_type field type, column_comment field comment from Information_schema. ' COLUMNS ' where table_schema= ' coordinate '

Export MySQL table notes and field notes to do a data dictionary