数据库字段及描述

SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释   FROM information_schema.COLUMNS WHERE table_name = '表名' AND table_schema = '数据库';