This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join syntax
>Date: Tue, 10 Jul 2001 13:57:37 -0300
>
>
>
>I have two databases (db1 e db2) on different hosts (host1 e host2). I put
>them
>on different hosts to split the charge (they are very big databases).
>
>However, I have to make some selects on tables of db2 filtering with
>information
>that are on db1.
>
>If db1 and db2 were at the same machine, I wouldn't have problem, because
>the
>table_reference would be "db1.table1 AS t1, db2.table2 AS t2". But as they
>are
>on different machines, I didn't know the syntax of the table_reference or
>even
>if it was possible.
>
>Thanks,
>
>Rodney
>
>
>
>
>
>
>
>Werner Stuerenburg <[EMAIL PROTECTED]> em 10/07/2001 10:51:39
>
>Favor responder a Werner Stuerenburg <[EMAIL PROTECTED]>
>
>
>
>
>
>
>
>
> Para: RODNEY ANTONIO RAMOS RODNEYR/Embratel@Embratel
>
> cc: [EMAIL PROTECTED]
>
>
>
> Assunto: Re: Join syntax
>
>
>
>
>
>
>
>
>
>As it seems, it is not possible. You would have to have a
>connection which talks to two databases at once, which may not be
>possible at all, at least create numerous problems.
>
>But I think it should be possible to create a temporary table in
>db 2 and copy the table from db1 into it, then do a join with
>that temporary table.
>
>Question is: what kind of an application do you have that you
>need such a thing?
>
> > Is it possible to join two tables from different databases that are
>located
> > on different hosts?
>
>
>--
>Herzlich
>Werner Stuerenburg
>
>_________________________________________________
>ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
>Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
>http://pferdezeitung.de
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
