[Resolved] Query for more than one Database

[moboter]

I need some help. I need to create a query that queries several databases which all have the same setup and write the data into one table, appending the data from all the queried databases.

Is that possible?

If so how can you do it😕

[bad76]

Hi,
when you make the query, use the dbname.tablename instead of tablename:

SELECT * FROM Db1.Main d1, Db2.Slave d2 WHERE d1.field=d2.field

The only tie is the Db1 and Db2 are in the same server.

bye bye

[Sxooter]

Keep in mind that cross database queries aren't supported by all databases, and they tend to be slow when they are.

Cross schema queries are SQL spec, but only a few databases support them, however, they tend to be very fast, since queries all exist within a single database instance.

Also note that there's no guarantee of any kind of transactional nature in cross db queries.

Just FYI.