MySQL multiple remote database join

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

MySQL multiple remote database join

Post by jaoudestudios »

Hi all,

Its been a while. I started a new job so have not been around much.

I am trying to do a join across 2 databases that are on different servers. I can do a join across the 2 databases if they are on the same server.

Is it possible if they are on different servers?

Thanks.
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: MySQL multiple remote database join

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: MySQL multiple remote database join

Post by jaoudestudios »

Thanks for the quick reply.

Not the answer I was hoping for though :(

Cheers :)
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: MySQL multiple remote database join

Post by jaoudestudios »

Apparently it is possible...
http://stackoverflow.com/questions/3382 ... sql/569011
Dont know full details yet, I added a comment to confirm.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: MySQL multiple remote database join

Post by jaoudestudios »

Ignore what I said, they are on the same server. :(
Post Reply