|
|
Posted by Snef on 07/26/06 20:53
mootmail-googlegroups@yahoo.com wrote:
> 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".
>
I assume that they need to be in the same MySQL?
Navigation:
[Reply to this message]
|