mysql 表字段名查询

查询数据库中表的所有字段名及类型

select COLUMN_NAME,DATA_TYPE,COLUMN_COMMENT from information_schema.COLUMNS where table_name = 'table_name' and table_schema = 'db_name';