一、Navicat导出Word表格
1. 查询出表结构
打开目标数据库(test)同级的 information_schema 数据库,执行以下SQL即可。
注意:test为数据库名称,user为表名
SELECT `COLUMNS`.ORDINAL_POSITION AS '序号', `COLUMNS`.COLUMN_NAME AS '字段名', `COLUMNS`.COLUMN_TYPE AS '类型(长度)', `COLUMNS`.NUMERIC_PRECISION AS '精度', `COLUMNS`.NUMERIC_SCALE AS '小数位数', `COLUMNS`.COLUMN_DEFAULT AS '默认值', IF( `COLUMNS`.IS_NULLABLE = 'YES', '√', '' ) AS '允许空', IF( `COLUMNS`.COLUMN_KEY = 'PRI', '√', '' ) AS '主键', `COLUMNS`.COLUMN_COMMENT AS '说明' FROM `TABLES` INNER JOIN `COLUMNS` ON `COLUMNS`.TABLE_SCHEMA = `TABLES`.TABLE_SCHEMA AND `COLUMNS`.TABLE_NAME = `TABLES`.TABLE_NAME WHERE `TABLES`.TABLE_SCHEMA = 'test' AND `TABLES`.TABLE_NAME = 'user'
2. 复制到word
复制完成后,打开Excel,粘贴到Excel表格上
再次全选,复制到Word上,选择 “使用目标样式”
3. 获取表注释
SELECT TABLE_COMMENT FROM `TABLES` WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'user'
4. 表头背景颜色设置:选中表头--->右键--->表格属性--->边框和底纹
标签:TABLES,WORD,NAME,COLUMN,Navicat,SQL,TABLE,COLUMNS,SCHEMA From: https://www.cnblogs.com/fangts/p/18218569