Can I join between two MySQL tables stores on separate machines?
Posted
by CuriousCoder
on Stack Overflow
See other posts from Stack Overflow
or by CuriousCoder
Published on 2010-05-20T09:10:10Z
Indexed on
2010/05/20
9:20 UTC
Read the original article
Hit count: 216
mysql
I have a relatively light query that needs information from a local MySQL table along with another MySQL table which is stored on a physically separate machine (on the same network). I'm keen to avoid setting up replication just to facilitate this light query that only needs executed once a day.
Is there any way that I can join with a table on a remote machine using one query? Or run a SELECT INTO into a local table.
Notes
- I'm using C# & .NET 4.
© Stack Overflow or respective owner