1. 查询中所有的表和表注释
SELECT
TABLE_NAME,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA.TABLES
WHERE
table_schema = '库名'
2. 查询表中所有字段和注释
SELECT
column_name,
column_comment
FROM
information_schema.COLUMNS
WHERE
table_name = '表名'
AND table_schema = '库名';