3

Is it possible to connect to a remote instance of mysql server from a stored procedure using sql statements, for select and insert access?

Ideally, it would be something like (pseudo-code):

connect to remotedb@remotehost
select field1 from remotedb.table1 where ...

I guess I can develop a user-defined function in C/C++ that does it by ODBC. I'd prefer a native syntax if possible, though. Thanks!

davka
  • 13,974
  • 11
  • 61
  • 86

1 Answers1

6

Yes. Using Federated tables feature.

Reddy
  • 8,737
  • 11
  • 55
  • 73
kedar
  • 116
  • 2