Well, not the way you seem to be implying. You must use your web application to create a connection to the other database. You can't join or union tables, just create the connection and run the query. Then your app can do what ever it wants with the data. Ken ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Chris Boget" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 12:11 PM Subject: Re: Query mysql on another server
> At 10:08 -0600 1/7/03, Chris Boget wrote: > >We have a *nix network and on that network we have 2 > >web servers. One for development (server1) and one for > >production (server2). And on each of those servers we > >have MySQL installed. Is there a way we can query a > >table on server2 from server1? > > No. > > >I know that when you are using a database from the mysql > >command line, you can query a table in another database > >just by using select databasename.tablename. But the > >same method using servername doesn't work. Is this even > >possible? > > No. > > > > >thnx, > >Chris > > 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
