Re: multiple db query
| From: | murugesan | Date: | Tue, 02 Sep 2003 11:07:40 +0000 |
| Subject: | Re: multiple db query | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-161436@lists.php.net to get a copy of this message | ||
I tried this and it is working well.
I use 2 DB namely db1 and db2
Mysql>use db1;
Mysql>select vv.visitorname,aa.visitorname from db1.visitordetails vv,
db2.visitordetails aa;
-Murugesan
----- Original Message -----
From: "Marek Kilimajer" <kilimajer@webglobe.sk>
To: "Aris Santillan" <aris@femalenetwork.com>
Cc: "Php (E-mail)" <php-general@lists.php.net>
Sent: Tuesday, September 02, 2003 4:29 PM
Subject: Re: [PHP] multiple db query
> For MySQL Version 3.23.25 and above - yes, and it is (surprisingly)
> called MERGE. I'm not sure if tables can be merged across databases.
> More in the manual.
>
> Aris Santillan wrote:
>
> > is it possible to query on 2 databases
> > but with same tablename and merge its output?
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>