topic Re: Looping different mysql databases in QlikView

Looping different mysql databases

darroyo_telcomu — Tue, 23 Feb 2016 12:46:51 GMT

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 — Tue, 23 Feb 2016 18:07:34 GMT

maybe this

can help you

HirisH_V7 — Tue, 23 Feb 2016 18:12:55 GMT

Hi ,

May be like this,

Data:

Connect to Server1.MyDatabase

tblTableA:

Load

SQL select tableA.*

From Server1.MyDatabase.tableA as tableA

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