select TABLE_SCHEMA 数据库名,TABLE_NAME 表名,COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释 from information_schema.COLUMNS where TABLE_SCHEMA=’table_name’;
