mysql 获取字段注释 和获取表字段

 获取字段类型和注释

Select COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释

from INFORMATION_SCHEMA.COLUMNS

Where table_name = 'table'##表名

AND table_schema = 'db_name'##数据库名

AND column_name LIKE 'id'##字段名

获取表字段 

select group_concat(column_name) as column_name from information_schema.columns where table_name = 'table名字' and table_schema='db数据库名字';