SELECT
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
DATA_TYPE 字段类型,
IS_NULLABLE 是否为空,
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT 备注
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'db_animal(数据库名)'
AND table_name = 'activity(表名)'
或者:
SELECT
COLUMN_NAME 列名,
COLUMN_COMMENT 字段解释,
COLUMN_TYPE 数据类型,
DATA_TYPE 字段类型,
IS_NULLABLE 是否为空,
CASE WHEN COLUMN_KEY = 'PRI' THEN '是' ELSE '否' END 是否为主键
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'db_animal'
AND table_name = 'activity'
导出后打开excel表将表格复制到word文档,得到:
接下来在word修改为三线图:
查看视图: