mysql 导出字典

SELECT
    col.TABLE_NAME,
    table1.table_comment,
    col.COLUMN_NAME,
    col.COLUMN_TYPE,
    col.COLUMN_COMMENT
FROM
    information_schema.columns as col
left join information_schema.tables as table1
on     table1.TABLE_NAME = col.TABLE_NAME
WHERE

    col.TABLE_SCHEMA='表名'