[Zope-DB] multidatabase connections

[Greg Fischer]

Cant you do a multiple db select in mysql?  I think you can, but not sure.

Something like this:

select db1.table.tablecol, db2.table.tablecol from db1.table, db2.table;

You'll have to check mysql reference manuals but if you can do that
then you'll get 1 resultset in one connection.  (more efficient that
way)

I guess this assumes you have the db's on the same server too.  I know
in MSSQL you can do this and I could swear Mysql could too, hmm....
now I have to learn mysql too. :)


On Mon, 7 Mar 2005 16:11:22 +1100, srikanth <srikanth.m at monsterfirst.com> wrote:
>  
>  
> 
> Hi, 
> 
>   I am new to zope and am working on project that needs me to interact with
> two different mysql databases to get my resultset. 
> 
> But with Zmysql database connection object I can connect to only one
> database. So how do I use my two databases to query at the 
> 
> Same time. 
> 
>   
> 
>    Any help would be greatly appreciated. 
> 
>   
> 
>  Ta. 
>  
> 
> ---
>  Outgoing mail is certified Virus Free.
>  Checked by AVG anti-virus system (http://www.grisoft.com).
>  Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005
>  
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
> 
> 
> 


-- 
Greg Fischer
1st Byte Solutions
http://www.1stbyte.com