SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '要查找的字段名称'
MySQL根据字段名查找数据库名和表名
最新推荐文章于 2024-04-23 19:39:55 发布
SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '要查找的字段名称'