MySQL Forums
Forum List  »  MySQL Workbench

Accessing remote data
Posted by: Martin Weaver
Date: May 23, 2017 08:13AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Accessing remote data
116
May 23, 2017 08:13AM
33
May 23, 2017 10:33AM
38
May 23, 2017 01:46PM
28
May 23, 2017 02:28PM
34
May 24, 2017 04:45AM


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.