SELECT * from (select column_name,TABLE_NAME from information_schema.columns where table_schema ='数据库名') a where a.column_name = "字段名"
在数据库中查找拥有某一个字段的表
最新推荐文章于 2024-08-04 10:06:58 发布
SELECT * from (select column_name,TABLE_NAME from information_schema.columns where table_schema ='数据库名') a where a.column_name = "字段名"