MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Query from multiple databases
Posted by: Peter Brawley
Date: April 19, 2012 04:50PM

You cannot query across connections. You will have to run the two queries separately, then combine the results in PHP.

An alternative possibility: on one server define FEDERATED tables pointing at tables on the other server,

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Query from multiple databases
Davor Ergotic
April 19, 2012 03:24PM
Re: Query from multiple databases
Peter Brawley
April 19, 2012 04:50PM
Re: Query from multiple databases
Rick James
April 21, 2012 01:36PM
Re: Query from multiple databases
Peter Brawley
April 21, 2012 09:09PM
Re: Query from multiple databases
Davor Ergotic
April 22, 2012 01:26PM
Re: Query from multiple databases
Peter Brawley
April 23, 2012 09:58PM
Re: Query from multiple databases
Davor Ergotic
April 26, 2012 03:00PM
Re: Query from multiple databases
obaid ahmed
April 28, 2012 12:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.