mysql数据库导出数据字典

 原文地址：https://blog.csdn.net/qq_45047809/article/details/113944103

csdn登录后才能复制，故转载过来方便复制。

导出hr和attendance表。

SELECT
    TABLE_NAME AS '表名',
    COLUMN_NAME AS '字段名',
    COLUMN_TYPE AS '数据类型',
    IS_NULLABLE AS '允许为空',
    EXTRA AS 'PK',
    COLUMN_COMMENT AS '字段说明' 
FROM
    information_schema.`COLUMNS` 
WHERE
    TABLE_SCHEMA = 'thinkcmf' and TABLE_NAME="cmf_user_params"

 

COLUMNS 表可用的字段

 

使用navcat导出excel