Hi,
Is there a command-line SQL interface or Perl module that allows you to
do a join between databases on different mysql servers? I've heard of
ODBC, but its specific functions are somewhat hazy to me. I've been
playing around with making a prototype that when given a query, extracts
queries specific to the various servers on which the databases exist,
but it's limited in its functionality and making a full-fledged program
is more work than I have time to do.
To give a simple example: knowing that databaseX is on server1 and
databaseY is on server2, I want to enter this query either through perl
or command line:
SELECT x.field1,y.field1 FROM databaseX.tableX AS x LEFT JOIN
databaseY.tableY AS y ON x.field2=y.field2 WHERE x.field3=10;
I avoided inventing my own syntax for inserting the server. I just made
a hash in my prototype that determines what server a database is on. Is
there a standard for that in SQL?
Thanks,
Rob
--
MS M888
McClintock Resource, Bioinformatics & Computational Biology
Bioscience Division
Los Alamos National Laboratory
Los Alamos, NM 87545
505-667-2307
---------------------------------------------------------------------
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
