Mysql Navicat数据字典导出

一：SQL

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

二：查询结果：

三：导出步骤