1. SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
2. FROM information_schema.COLUMNS
3. WHERE COLUMN_NAME = '要查找的字段名称'
MySQL根据字段名查找数据库名和表名
最新推荐文章于 2023-08-01 10:43:01 发布
1. SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
2. FROM information_schema.COLUMNS
3. WHERE COLUMN_NAME = '要查找的字段名称'