Posted by mootmail-googlegroups on 07/26/06 20:21

noor.rahman@gmail.com wrote:
> I was wondering how it may be possible to query 2 MySQL databases using
> one query statement from PHP.
>
> For instance: SELECT database1.tableA.field1 UNION
> database2.tableB.field2.
>
> My concern is, when connecting to MySQL (or sending a query), I only
> specify 1 database connection resource ID. How does that play out when
> connecting to 2 databases?
>
> Thanks.


As I understand it, the database you specify when connecting to mysql
is your default database. For example, if you connect using "db1",
then to query that database, you can just use "SELECT * FROM table1"
which, because of your default database, is equivalent to "SELECT *
FROM db1.table1". You are still able to access other databases by
fully-qualifying the names, so even if "db1" is your default database,
you can still do something like "SELECT * FROM db2.table2".

• Next in forum: Re: HELP - sure is a piece of cake for you
• Prev in forum: Re: FastCGI and DB connections / global variables?
• Thread view: Re: Query 2 MySQL databases in 1 statement

[Reply to this message]