导购类网站建设多少钱/长沙seo推广外包

select column_name,column_comment,data_type from information_schema.columns where table_name='你的表名'

PLUS:

查询dababase下所有表名及表注释

SELECT TABLE_NAME,TABLE_COMMENT FROM information_schema.TABLES WHERE table_schema='database名';