Possible Duplicate:
can I access a remote mysql server/db from a stored procedure?
Is it possible to access another mysql server from stored procedure?
Asked
Active
Viewed 5,569 times
0
-
Perhaps you'll find an answer to your question in this [topic](http://database.ittoolbox.com/documents/connecting-to-and-accessing-a-sql-server-database-on-another-server-18751). – kapandron Aug 23 '12 at 12:00
2 Answers
0
In MySQL access tables from different servers from a single connection is federated tables: http://dev.mysql.com/doc/refman/5.0/en/federated-use.html Once you do that, it like access to a local table.
Rena Sun
- 285
- 1
- 3
- 8
0
You can try to create a UDF which is user-defined function. You only should create and install this function into MySQL. It may be a little bit difficult, but you could try it.
And a simple way to access tables is to use federated engine (as Rena Sun suggested), was answered here - MySQL — Joins Between Databases On Different Servers Using Python?.
