select table_name from information_schema.columns
where table_schema = '库名' and column_name='字段名';
在数据库中查找某个字段在哪张表里
于 2021-09-13 17:23:20 首次发布
select table_name from information_schema.columns
where table_schema = '库名' and column_name='字段名';