时间:2018-07-02 15:18:26
SELECT
TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
COLUMN_TYPE,
COLUMN_COMMENT
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = '库名'
带表注释的
SELECT
a.TABLE_SCHEMA '数据库',
a.TABLE_NAME '表名',
t.TABLE_COMMENT '表描述',
a.COLUMN_NAME '字段名称',
a.COLUMN_TYPE '字段类型',
a.COLUMN_COMMENT '字段备注'
FROM
information_schema.COLUMNS a
LEFT JOIN TABLES t ON a.`TABLE_NAME` = t.`TABLE_NAME`
WHERE
a.TABLE_SCHEMA = '库名'
# 过滤视图
AND t.TABLE_COMMENT != 'VIEW';