Re: Selecting across servers
Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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
RE: Selecting across servers
How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Re: Selecting across servers
At 15:00 -0600 3/13/02, Cal Evans wrote: Is it possible to issue 1 select that gathers data from databases on 2 separate servers? No. Every now and then, someone alleges that this can be done. But it always turns out to be someone who hasn't actually tried it. :-) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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
RE: Selecting across servers
At 15:13 -0800 3/13/02, David Buerer wrote: How do you do it from different databases on the same server? Qualify your table names with the database name. SELECT db1.tbl1.*, db2.tbl2.* FROM db1.tbl1, db2.tbl2 WHERE ... If db1 or db2 happen to be the current database, you don't need to qualify references to its tables. David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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
RE: Selecting across servers
SELECT * FROM database1.table1 ... database2.table2 ... WHERE -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across servers How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - 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
RE: Selecting across servers
SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across servers How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - 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
RE: Selecting across servers
Gee guys, thanks for the quick answers. Juding by the number of responses you'd think that I asked a simple question! I'm on a 48hr development spree using MySQL for the firts time so I haven't gotten knee deep in the documentation yet. It's a great program though...fast...not bloated..simple...feature rich...no buffer overruns...What more can I say? Thanks again, David -Original Message- From: Gurhan Ozen [EMAIL PROTECTED] To: David Buerer [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Wed, 13 Mar 2002 18:29:34 -0500 Subject: RE: Selecting across servers SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across servers How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - 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
RE: Selecting across servers, JDBC
Hi, all: I tried with JDBC, it seem that this is not working. mm.mysql JDBC will ignore the database name. Do anyone have the some issues? Zengfa --- David Buerer [EMAIL PROTECTED] wrote: Gee guys, thanks for the quick answers. Juding by the number of responses you'd think that I asked a simple question! I'm on a 48hr development spree using MySQL for the firts time so I haven't gotten knee deep in the documentation yet. It's a great program though...fast...not bloated..simple...feature rich...no buffer overruns...What more can I say? Thanks again, David -Original Message- From: Gurhan Ozen [EMAIL PROTECTED] To: David Buerer [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Wed, 13 Mar 2002 18:29:34 -0500 Subject: RE: Selecting across servers SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across servers How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - 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 - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - 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 __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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