join tables from multiple mysql host

Question

I have 2 tables in different databases in different mysql hosts. can i write a single SQL statement to implement the inner join operation？

possible duplicate of PHP-Mysql table join from different host — Shakti Singh
– Shakti Singh, Commented Mar 31, 2012 at 6:40
Does this answer your question? Join tables from two different server — Nico Haase
– Nico Haase, Commented May 26, 2023 at 8:58

BluesRockAddict · Accepted Answer · 2012-03-31 06:42:13Z

1

Depending on your MySQL version, you might be be able to use Federated Storage Engine. Refer to Accessing Distributed Data with the Federated Storage Engine for more information.

answered Mar 31, 2012 at 6:42

BluesRockAddict

15.6k3 gold badges40 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Adler · Accepted Answer · 2012-03-31 06:41:00Z

0

That would mean connecting to another MySQL host from INSIDE the SQL statement. To my knowledge, this is not possible and I would regard it as highly dangerous if it were.

answered Mar 31, 2012 at 6:41

Mike Adler

1,2009 silver badges24 bronze badges

Comments

Unos · Accepted Answer · 2012-03-31 06:46:08Z

0

It is not possible to join two tables from different hosts. You can store the result from one of the tables in a hash keyed on the join attribute, and then perform the join operation in your program.

answered Mar 31, 2012 at 6:46

Unos

1,3692 gold badges15 silver badges35 bronze badges

Comments

Michal · Accepted Answer · 2012-03-31 13:07:56Z

-4

it is not possible to connect to two databases in same query

edited Mar 31, 2012 at 13:07

Michal

3,3524 gold badges33 silver badges51 bronze badges

answered Mar 31, 2012 at 6:42

manishbagra

584 bronze badges

2 Comments

Fabrizio Over a year ago

to two database it is possible: SELECT db1.tb1.* FROM db1.tb1 LEFT JOIN db2.tb1 ON db1.tb1.field1 = db2.tb1.field1. The question here was more about hosts than databases

Nico Haase Over a year ago

Pretty strange that there are a lot of other answers that claim that this is possible

Collectives™ on Stack Overflow

join tables from multiple mysql host

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related