Re: How to create DB link in MySQL
Posted by: Peter Brawley
Date: September 12, 2020 03:57PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
237
September 12, 2020 09:08AM
77
September 12, 2020 09:32AM
Re: How to create DB link in MySQL
81
September 12, 2020 03:57PM
28
February 22, 2021 08:31AM


Sorry, only registered users may post in this forum.

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.