能通过存储过程实现吗？

[flame100]

同一服务器下，有多个数据库(百来个），有相同结构的数据表tableA, 表有字段phone，能通过字段phone,查找出对应的数据库名吗？已知该字段数据不会同时出现在2个不同的数据库中。

[学海无涯-回头是岸]

information_schema.columns 和information_schema.tables就能查出来

[flame100]

引用 1 楼 baidu_36457652 的回复:

information_schema.columns 和information_schema.tables就能查出来

通过这两个，我只能查出包含phone字段的所有数据库，不能定位到哪个库吧？
本来想用游标实现判断，但怎么试都不行。

[zjcxc]

select table_schema, table_name from information_schema.columns where column_name='phone';

[ACMAIN_CHM]

select 'db01' as db from db01.tableA where phone='010-1234 5678' union all
select 'db02' as db from db02.tableA where phone='010-1234 5678' union all
select 'db03' as db from db03.tableA where phone='010-1234 5678' union all
select 'db04' as db from db04.tableA where phone='010-1234 5678' union all
select 'db05' as db from db05.tableA where phone='010-1234 5678' union all
...
select 'db99' as db from db99.tableA where phone='010-1234 5678'