查询所有表以及注释:
select table_name,table_comment from information_schema.tables where table_schema='数据库名称'
查询指定表的所有字段及注释:
select t.table_name as 表名,t.table_comment 表名注释,c.column_name 字段名,c.column_type 字段类型,c.column_comment 字段注释 from information_schema.columns c left join information_schema.tables t on c.table_schema=t.table_schema and c.table_name=t.TABLE_NAME
where c.table_schema='test' and t.table_name in('tableA')