Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
darroyo_telcomu
Partner - Contributor III
Partner - Contributor III

Looping different mysql databases

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.

2 Replies
maxgro
MVP
MVP

HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”