在数据库中搜索条目(不指定列名/表名) [英] Search for an entry - in a Database ( without specifying a Column name/Table name)

问题描述

是否可以在整个数据库中搜索条目而无需指定哪个表和哪个列?
并获取包含我们搜索的条目的表名，例如

Is it possible to search for an entry in a whole database without specifying which table and in which column ?
And get the Table name that contains the entry we searched , like

SELECT (Table name ? )FROM (Database - not Table) WHERE ( unknown column ?) = 'our value';

我的意思是结果应该是表名称本身.

I mean the result should be the Table name itself.

推荐答案

就我所知，没有内置的MySQL可以完成此任务，但是还有另一种方法.这不是一种非常有效的方法，但是如果您必须执行此操作，那么有一种方法！

As for as I know there is nothing built-into MySQL that accomplishes this, however there is an alternative. This is not a very efficient approach, but if you must do this there is a way!

http://code.google.com/p/anywhereindb/

这篇关于在数据库中搜索条目(不指定列名/表名)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！