一、生成表名、表注释内容
SELECT TABLE_NAME,TABLE_COMMENT
FROM information_schema.`TABLES`
WHERE TABLE_SCHEMA='目标数据库名字' AND TABLE_ROWS!='0'
ORDER BY TABLE_COMMENT DESC
二、生成表名、字段名、字段注释内容
SELECT table_name as 表名,COLUMN_NAME as 字段名,COLUMN_COMMENT as 字段注释内容
FROM information_schema.`COLUMNS`
where table_name in(
SELECT TABLE_NAME FROM information_schema.`TABLES` WHERE TABLE_SCHEMA='目标数据库名字' AND TABLE_ROWS!='0'
)
order by table_name desc