Re: Query multiple databases

[Rick James]

Let's parse this:
select ConnectIP from ( select concat_ws('.',TABLE_SCHEMA,TABLE_NAME) from information_schema.TABLES where TABLE_NAME = "access") as t2;

There is a subquery in the FROM clause:
select concat_ws('.',TABLE_SCHEMA,TABLE_NAME) from ...
that is selecting one column:
concat_ws('.',TABLE_SCHEMA,TABLE_NAME)
which is, by default, called
"concat_ws('.',TABLE_SCHEMA,TABLE_NAME)"

So, that is the only field available for the outer query to fetch.

To achieve your goal, you would need to create and execute 1300 SELECTs. (Hmmm... Smells like the schema was not well designed. Usually, having lots of similar databases is a 'mistake'.)

So, how to solve the problem? Build a stored procedure. It would
1. find the 1300 db.tbl pairs
2. loop through them (using a cursor):
3. build a SELECT, PREPARE and EXECUTE it.
This would give you 1300 resultsets; you may prefer to INSERT each SELECT's output into a temp table, then SELECT all of the temp table.