SELECT
COLUMN_NAME AS 字段名称,
COLUMN_TYPE AS 数据类型,
IF(COLUMN_KEY='PRI','Y','N') AS 主键,
COLUMN_COMMENT AS 备注
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_schema = '数据库名'
AND
TABLE_NAME = '表明'
数据库表结构信息查询
最新推荐文章于 2022-10-24 09:29:45 发布