1. SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
2. FROM information_schema.COLUMNS
3. WHERE COLUMN_NAME = '要查找的字段名称'
MySQL根据字段名查找数据库名和表名
最新推荐文章于 2025-06-05 11:33:32 发布
1. SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
2. FROM information_schema.COLUMNS
3. WHERE COLUMN_NAME = '要查找的字段名称'