开发者

can I access a remote mysql server/db from a stored procedure?

Is it possible to connect to a remote instance of mysql server from a stored开发者_如何学C 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!


Yes. Using Federated tables feature.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜