导出mysql数据库数据字典


USE information_schema;
SELECT
T.TABLE_NAME as '表名',
T.TABLE_COMMENT as '表说明', 
C.COLUMN_NAME AS '字段名',
C.COLUMN_COMMENT AS '字段说明',
C.COLUMN_TYPE AS '数据类型',
C.IS_NULLABLE AS '允许为空',
C.EXTRA 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 = '表名' 
发布于
标记为