mysql 查询字段名所在的表

select * from (select * from information_schema.COLUMNS where table_schema = '数据库名') temp where column_name = '字段名'

转载于:https://www.cnblogs.com/zonglonglong/p/9936581.html