数据库设计查询

SELECT COLUMN_NAME AS 字段名,
COLUMN_TYPE AS 数字类型,
COLUMN_COMMENT AS 备注
FROM
information_schema.COLUMNS
where
TABLE_SCHEMA='content'    --库名
AND
table_name='oil_company_config_info'  ---表名