SQL query in 2 database on different (mysql) servers

Asked

Viewed 259 times

0

Hello.

First of all, I make it clear that I don’t know if this is possible.

I am trying to make an SQL query where I need the union data (INNER JOIN) of 02 tables that are on different servers (One Local Server and another Remote Server).

I want to do it in PHP using mysqli. But I tried everything and I couldn’t.

If anyone knows and can help me I’d be very grateful.

From now on, thank you.

  • https://answall.com/questions/245824/como-fazer-um-inner-join-entre-dois-bancos-diferentes-no-mesmo-servidor-no-mysql

  • Hello Friend. Thank you for the answer, but unfortunately it’s not what I want. By what I intended in the link you sent, this method only works in local database. In my case one database is local and the other is remote.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.