i don't have any problem when joining table on different database in same server, but when the database is separate let say database A on server A and database B on server B how can i join table from server A and database A to table in server B and database B? If is possible, how? And if not, what is the best method for me to do? im using php and mysql for my database. thanks...
Asked
Active
Viewed 627 times
0
-
how about different server? i don't have any problem on same server.. the problem when database A on server A and database B on server B – Mas Ai Jun 08 '17 at 15:40
-
1 = Yes..., 2) depends on the other database server – RiggsFolly Jun 08 '17 at 15:41
-
https://stackoverflow.com/questions/11114197/join-tables-from-two-different-server this one stands to be a duplicate. Edit: and/or https://stackoverflow.com/questions/8752477/joining-tables-from-different-servers - You could have Google'd this, if you haven't. – Funk Forty Niner Jun 08 '17 at 15:41
-
Any other recommendations besides FEDERATED ENGINE ? – Mas Ai Jun 08 '17 at 15:53