Re: Call Procedure in MySQL from another MySQL
In whatever client you're using, you'd need to connect to the MySQL instance on the other server, logging in as a user with privs for that sproc and what it does.
If the client is the MySQL client program, you'd need to run another instance of the client program. The 2nd instance would know nothing of the first instance unless you passed it commandline arguments carrying that info.
If the client were an app written in a language for which there's a MySQL API (PHP, Python, C#, Java &c), you could initialise and make a 2nd connection, to which you could pass values that the app had assembled from the first connection. Note however that each connection's routines would be running against just the server to which its connected.
Subject
Views
Written By
Posted
761
August 04, 2019 09:02PM
Re: Call Procedure in MySQL from another MySQL
404
August 04, 2019 09:18PM
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.