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.
MySQL multiple remote database join
Moderator: General Moderators
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: MySQL multiple remote database join
There are 10 types of people in this world, those who understand binary and those who don't
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: MySQL multiple remote database join
Thanks for the quick reply.
Not the answer I was hoping for though
Cheers
Not the answer I was hoping for though
Cheers
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: MySQL multiple remote database join
Apparently it is possible...
http://stackoverflow.com/questions/3382 ... sql/569011
Dont know full details yet, I added a comment to confirm.
http://stackoverflow.com/questions/3382 ... sql/569011
Dont know full details yet, I added a comment to confirm.
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: MySQL multiple remote database join
Ignore what I said, they are on the same server. 