通过字段名找表名: SELECT TABLE_NAME FROM information_schema.COLUMNS WHERE table_schema='数据库名' AND column_name = '字段名'