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