SELECT
r.TABLE_COMMENT AS "表名",
t.TABLE_NAME AS "表名",
t.COLUMN_NAME AS "列名",
t.COLUMN_COMMENT AS "列名",
t.DATA_TYPE AS "数据类型",
t.COLUMN_TYPE AS "数据类型",
t.IS_NULLABLE AS "非空",
t.COLUMN_DEFAULT AS "默认值",
t.COLUMN_KEY AS "数据类型",
t.EXTRA AS "其他"
FROM
information_schema.`COLUMNS` t,
information_schema.`TABLES` r
WHERE
t.TABLE_SCHEMA = 'creator'
AND t.TABLE_NAME = r.TABLE_NAME;
通过sql查询mysql数据字典
最新推荐文章于 2024-06-18 14:40:57 发布