Re: Join data from 2 mysql servers ??

2004-12-07 Thread Gleb Paharenko
Hello. This question often appears in the list. You can't join tables between databases residing on different MySQL servers. Rakesh Gupta <[EMAIL PROTECTED]> wrote: > When I am logged on to a particular mysql server, is it possible to > - Access table residing on a different mysqlserve

Re: Join data from 2 mysql servers ??

2004-12-07 Thread Kieran Kelleher
I guess you would would have to write some custom code that has connections to each database server and operates outside of MySQL to do this. For example, WebObjects (www.webobjects.com) allows you to have multiple EOModels (Enterprise Object models) in a project, each EOModel can represent a

Join data from 2 mysql servers ??

2004-12-06 Thread Rakesh Gupta
When I am logged on to a particular mysql server, is it possible to - Access table residing on a different mysqlserver? or - To join tables between two databases residing on two different mysql servers (on two different H/W boxes or same H/W box). Any Ideas I looked in the manual. It talks