habby's blog - 2023年1月
type: channel
link: https://www.habby.top/2023/01/
description: 互联网上的文章真TM不靠谱 还是自己来的好 --只写靠谱的文档
items: 导出mysql数据库数据字典

导出mysql数据库数据字典
type: item
date: 2023-01-09T15:48:58+08:00
description: USE information_schema; SELECT T.TABLE_NAME as '表名', T.TABLE_COMMENT as '表说明', C.COLUMN_NAME AS '字段名', C.COLUMN_COMMENT AS '字段说明', C.COLUMN_TYPE AS '数据类型', C.IS_NULLABLE AS '允许为空', C.EXTRA AS '其他属性' FROM COLUMNS C INNER JOIN TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMA AND C.TABLE_NAME = T.TABLE_NAME WHERE T.TABLE_SCHEMA = '表名'