mysql获取注释

2021-07-14  本文已影响0人  一曲三月

-- 获取注释
SELECT table_name 表名,table_comment 表说明 FROM information_schema.TABLES ORDER BY table_name
Select COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释 from INFORMATION_SCHEMA.COLUMNS

-- --查询字典
SELECT
TABLE_SCHEMA AS '数据库',
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
COLUMN_TYPE AS '字段类型',
COLUMN_COMMENT AS '字段解释'
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = 'database_name(这里是要查询的数据库)'

上一篇 下一篇

猜你喜欢

热点阅读