0

I have 2 databases on the two different servers. I am using MySQL

Server 1 has the Database: LookupDB Server 2 has the Database: TranscationDB

Now, I want to create one stored procedure in TranscationDB which needs some data from LookupDB.

How can I achieve this?

Thanks.

jarlh
  • 42,561
  • 8
  • 45
  • 63
Mittal Patel
  • 2,732
  • 14
  • 23
  • Yes you can, it's called `Linked Servers`. Take a look at this [question](https://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server) – KaeL Mar 28 '18 at 10:18
  • 1
    ` Linked Servers` is for SQL server, and my question is for MySQL – Mittal Patel Mar 28 '18 at 10:22
  • You should specify which tools for mysql are you talking about: command line, phpmysql, ... – kiks73 Mar 28 '18 at 10:23
  • @Mittal got it! – KaeL Mar 28 '18 at 10:29
  • @kiks73, I am using simple mysql server and any IDE to connect it like workbench, sqlyog etc.. As I mentioned I want to create stored procedure for this – Mittal Patel Mar 28 '18 at 10:31

0 Answers0