select TABLE_SCHEMA 数据库名,TABLE_NAME 表名,COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释
from information_schema.`COLUMNS`
where TABLE_SCHEMA='<数据库>'
select TABLE_SCHEMA 数据库名,TABLE_NAME 表名,COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释
from information_schema.`COLUMNS`
where TABLE_SCHEMA='<数据库>'