SELECT DISTINCT TABLE_NAME, TABLE_SCHEMA
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = '已知某字段名';
MySQL:已知某字段名,查找包含此字段名的表名
于 2024-04-23 19:39:55 首次发布
SELECT DISTINCT TABLE_NAME, TABLE_SCHEMA
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = '已知某字段名';