MySQL查询表字段和字段备注

Select COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释  
from INFORMATION_SCHEMA.COLUMNS  
Where table_name = '表名称' AND table_schema = '数据库名称';