Re: How to create DB link in MySQL
Again, the preferred way is to replicate data to a server that has all data required for such a query.
Failing that, the "Federated" storage engine allows limited inter-server functionality.
Otherwise you'll need to bring the two datasets together in the buffers of an app (PHP, C# &c) and emulate the Join logic there.
Subject
Views
Written By
Posted
16961
September 12, 2020 09:08AM
4288
September 12, 2020 09:32AM
2817
September 12, 2020 12:47PM
Re: How to create DB link in MySQL
2866
September 12, 2020 03:57PM
2381
February 22, 2021 08:31AM
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.