mysql生成数据字典
mysql5.5 代码
SELECT
C.TABLE_NAME AS '表',
T.TABLE_COMMENT AS '表名',
C.COLUMN_NAME AS '字段名',
C.COLUMN_TYPE AS '数据类型',
C.IS_NULLABLE AS '允许为空',
C.COLUMN_COMMENT AS '字段说明',
C.COLUMN_KEY AS '键'
FROM
COLUMNS C
INNER JOIN TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMA
AND C.TABLE_NAME = T.TABLE_NAME
WHERE
T.TABLE_SCHEMA = 'tzps'
执行效果如下
2020年5月29日更新
感谢网友 cathybi提出错误,上面给出的代码在mysql5.5可用,在5.7上有问题,下面给出5.7的代码。
mysql5.7 代码
SELECT
C.TABLE_NAME AS '表',
T.TABLE_COMMENT AS '表名',
C.COLUMN_NAME AS '字段名',
C.COLUMN_TYPE AS '数据类型',
C.IS_NULLABLE AS '允许为空',
C.COLUMN_COMMENT AS '字段说明',
C.COLUMN_KEY AS '键'
FROM
INFORMATION_SCHEMA.COLUMNS C
INNER JOIN INFORMATION_SCHEMA.TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMA
AND C.TABLE_NAME = T.TABLE_NAME
WHERE
T.TABLE_SCHEMA = 'tzps'