Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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