information_schema.COLUMNS
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME

information_schema.TABLES

select  TABLE_NAME,TABLE_COMMENT from information_schema.TABLES 
where TABLE_SCHEMA='dbname' and TABLE_NAME like 'xxx%' 


SELECT
column_name AS '列名',
data_type AS '数据类型',
character_maximum_length AS '字符长度',
numeric_precision AS '数字长度',
numeric_scale AS '小数位数',
is_nullable AS '是否允许非空',
CASE WHEN extra = 'auto_increment'
THEN 1 ELSE 0 END AS '是否自增',
column_default AS '默认值',
column_comment AS '备注'

from information_schema.COLUMNS

where TABLE_SCHEMA='dbname' and TABLE_NAME = 'tablename'