MySQL dbForge - Querying between different connections (same schema) [duplicate]
This question already has an answer here:
Join between tables in two different databases?
3 answers
I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).
Here is my situation:
Connection: DB1, Schema: My_schema, Table: APIKeys
Connection: DB2, Schema: My_schema, Table: Coupons
Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.
Happy New Year! Wish you all the best in 2019!
Looking forward to your replies. ;)
mysql schema dbforge
asked Jan 1 at 19:16
BlueDevBlueDev
41638
marked as duplicate by Shadow mysql
Users with the mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 23:28
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
Join between tables in two different databases?
3 answers
I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).
Here is my situation:
Connection: DB1, Schema: My_schema, Table: APIKeys
Connection: DB2, Schema: My_schema, Table: Coupons
Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.
Happy New Year! Wish you all the best in 2019!
Looking forward to your replies. ;)
mysql schema dbforge
asked Jan 1 at 19:16
BlueDevBlueDev
41638
marked as duplicate by Shadow mysql
Users with the mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 23:28
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46
add a comment |
This question already has an answer here:
Join between tables in two different databases?
3 answers
I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).
Here is my situation:
Connection: DB1, Schema: My_schema, Table: APIKeys
Connection: DB2, Schema: My_schema, Table: Coupons
Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.
Happy New Year! Wish you all the best in 2019!
Looking forward to your replies. ;)
mysql schema dbforge
asked Jan 1 at 19:16
BlueDevBlueDev
41638
This question already has an answer here:
Join between tables in two different databases?
3 answers
I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).
Here is my situation:
Connection: DB1, Schema: My_schema, Table: APIKeys
Connection: DB2, Schema: My_schema, Table: Coupons
Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.
Happy New Year! Wish you all the best in 2019!
Looking forward to your replies. ;)
This question already has an answer here:
Join between tables in two different databases?
3 answers
mysql schema dbforge
mysql schema dbforge
asked Jan 1 at 19:16
BlueDevBlueDev
41638
asked Jan 1 at 19:16
BlueDevBlueDev
41638
asked Jan 1 at 19:16
BlueDevBlueDev
41638
asked Jan 1 at 19:16
BlueDevBlueDev
41638
asked Jan 1 at 19:16
BlueDevBlueDev
41638
41638
marked as duplicate by Shadow mysql
Users with the mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 23:28
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Shadow mysql
Users with the mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 23:28
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46
add a comment |
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46
add a comment |
1 Answer
1
active
oldest
votes
In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..
select a.col1, b.col1
from db1.table1 a
inner join db2.table2.col2 b on a.keycol = b.colkey
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..
select a.col1, b.col1
from db1.table1 a
inner join db2.table2.col2 b on a.keycol = b.colkey
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
add a comment |
In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..
select a.col1, b.col1
from db1.table1 a
inner join db2.table2.col2 b on a.keycol = b.colkey
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
add a comment |
In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..
select a.col1, b.col1
from db1.table1 a
inner join db2.table2.col2 b on a.keycol = b.colkey
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..
select a.col1, b.col1
from db1.table1 a
inner join db2.table2.col2 b on a.keycol = b.colkey
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
answered Jan 3 at 11:54
scaisEdgescaisEdge
95.3k105071
95.3k105071
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
add a comment |
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..."
– BlueDev
Jan 7 at 20:16
add a comment |
the dbs are on the same server of are on different servers ??
– scaisEdge
Jan 1 at 19:19
Yep. They are on the same server.
– BlueDev
Jan 3 at 11:46