mysql 生成数据字典sql语句

SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    COLUMN_NAME,
    COLUMN_TYPE,
    COLUMN_COMMENT
FROM
    information_schema. COLUMNS
WHERE
    TABLE_SCHEMA = '数据库名称'