获取字段类型和注释
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数据库名字';