SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名'
AND TABLE_NAME = '表名';
MySQL查询表的所有字段名
最新推荐文章于 2024-04-15 18:02:49 发布
SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名'
AND TABLE_NAME = '表名';