mysql中查询某字段所在的表方法

select TABLE_NAME from information_schema.COLUMNS where COLUMN_NAME = 'type'

原文地址:https://www.cnblogs.com/imeng/p/4497434.html