通过这个查到所有的表,再通过这个结果来查询对应表的对应字段值
select table_name from information_schema.columns where table_schema = '库名' and column_name='字段名';
效果如下:
select table_name from information_schema.columns where table_schema = '库名' and column_name='字段名';
效果如下: