查看指定库和表下的字段信息
SELECT
COLUMN_NAME AS '字段名',
DATA_TYPE AS '数据类型',
COLUMN_KEY AS '键约束',
IS_NULLABLE AS '是否可为空',
COLUMN_COMMENT AS '注释'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = '' -- 数据库名
AND TABLE_NAME = ''; -- 表名