Re: MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

2007-08-10 Thread krishna chandra prajapati
Hi Everybody, If any body knows how to implement federated storage engine and how to setup it. How it works. Please enrich me also. -Regards, Krishna On 8/10/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Its not possible in innodb or myisam engine, you can do it using fedrated > if i am not wr

Re: MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

2007-08-10 Thread Ananda Kumar
Its not possible in innodb or myisam engine, you can do it using fedrated if i am not wrong. regards anandkl On 8/10/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > > Hi All, > > There are two mysql server. I need to retrive data from two different > hosts > (mysql server) and by usi

MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

2007-08-10 Thread krishna chandra prajapati
Hi All, There are two mysql server. I need to retrive data from two different hosts (mysql server) and by using a join make a query. Is it possible to make a query which can fetch data from two different mysql server using join. -Regards, Krishna