select column_name,column_comment,data_type
from information_schema.columns
where table_name='表名' and table_schema='数据库名'
select column_name,column_comment,data_type
from information_schema.columns
where table_name='表名' and table_schema='数据库名'