select
TABLE_NAME,
TABLE_COMMENT
from
INFORMATION_SCHEMA.Tables
where
table_schema = '数据库名'
SELECT
TABLE_NAME AS '表名',
COLUMN_NAME AS '列名',
COLUMN_COMMENT AS '注释'
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = '数据库名'
ORDER BY TABLE_NAME, ORDINAL_POSITION;