WG: querying multiple database

I know of two possibilities.

1. If you have a C or C++ program, connect to host1 and fetch result-se=
t-1.
switch the connection to host2 and fetch result-set-2.
then merge the result-sets and process them

2. create a third database, copy the from host1 and host2 via mysqldump=
and
process it.
if possible, transfer only the data you want to process.


mit freundlichen Grüßen

Thomas Treffehn

Hans Brochier GmbH & Co KG

Abteilung S2 - Informationswesen
Marthastraße 16
90482 Nürnberg

Fon: +49 0911-9543-355
Fax: +49 0911-9543-383
www.brochier.de

----- Weitergeleitet von Thomas Treffehn/BROCHIER/DE am 21.06.2005 08:5=
0
-----
=

Pradeep Bojan =


com> =
An
win32@lists.mysql.com =

21.06.2005 06:34 Ko=
pie
=

Th=
ema
querying multiple database =

=

=

=

=

=

=





Hi,

I have two database in different machine. The structure of the table i=
n
both the database is the same. Only records are different. I want to=

query records from both the database and process the results. How can =
I
do this ?

Database 1: abcd@host1.com
Database 2: abcd@host2.com

'abcd' has 4 tables. The structure is same in both machines.

Please let me know.

Thanks,
Pradeep





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dtreffehn@brochi=
er.de
=



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org