Accessing remote data
Ok I am going to do my best as describing this. I have 1 server located at 192.169.0.11 and i have 1 PC located at 192.168.0.171 both of them have mysql on them. On the PC i have a tabled called CSM2, what i want to be able to do is retrieve the information for the table CSM2 on the server pc.
From what i have read MySql does not have the same ability at Microsoft SQL where in the command line you can say: Select * from SERVER.database.dbo.table
Or can it be done the above way?
If not is federated the only and best way to do this?
And how do you enable it in a windows environment? not in command line
Subject
Views
Written By
Posted
Accessing remote data
1083
May 23, 2017 08:13AM
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.