Looping different mysql databases

[darroyo_telcomu]

Hi all,

I have a mysql table containing the names of several databases, and I want to make the same query in that databases.

So I would need something like that:

select db from mydatabases;

for( every db in mydatabases )

{

  select name from db.employees;

}

Can anyone give me an idea of how to manage with this?

Thanks in advance.

Best regards,

David.

[maxgro]

maybe this

Use database names from Excel sheet in a For Loop for Connection String.‌

can help you

[HirisH_V7]

Hi ,

May be like this,

Data:

1.

Connect to Server1.MyDatabase

tblTableA:

Load

SQL select tableA.*

From Server1.MyDatabase.tableA as tableA

2.

Connect to Server1.MyDatabase

tblTableB:

Load

SQL select tableB.*

From Server2.MyDatabase.tableB as tableB

You can call as resident table .By Making Joins  You required to all Tables.

HTH,

Hirish