select column_name as 字段类型,
     column_type as 数据类型,
     data_type as 字段类型,
     character_maximum_length as 长度,
     is_nullable as 是否为空,
     column_default as 默认值,
     column_comment as 备注
from
     information_schema.columns
where
     table_schema = ‘数据库名称‘ and table_name = ‘表名称‘