Navicat快速导出mysql表字段属性注释等相关信息
2019-06-28 本文已影响0人
SshineLee
查询语句
SELECT
COLUMN_NAME 字段,
COLUMN_COMMENT 名称,
COLUMN_TYPE 类型,
IF
( column_key = 'PRI', '是', '否' ) 主键,
IF
( IS_NULLABLE = 'YES', '是', '否' ) 是否为空,
COLUMN_COMMENT 注释
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = '数据库名称'
AND table_name = '表名称'
示例
![](https://img.haomeiwen.com/i6711378/1f2d31c28e1ea224.png)
导出
![](https://img.haomeiwen.com/i6711378/584d7b03e564d28e.png)
导出WORD
![](https://img.haomeiwen.com/i6711378/b56f01527b82d1bb.png)
选择导出路径
![](https://img.haomeiwen.com/i6711378/5fb829e585efb0c6.png)
后面一直下一步就可以了