mysql 查詢字段名所在的表

select * from (select * from information_schema.COLUMNS where table_schema = '資料庫名') temp where column_name = '字段名'

轉載于:https://www.cnblogs.com/zonglonglong/p/9936581.html