Is there a way to let MySQL join some external data without importing those data into DB?
Multi tool use
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
1
I have some static data which stored in a JSON file:
outinfo=
[{out_id:123,out_name:'hello'}]
and I have a table:
----tableA----
| id | label | out_id |
| 1 | a | 123 |
| 2 | b | 123 |
I wanna select all info out like
{id:1,label:"a",out_name:"hello"}
It is easy to achieve that by importing the outside JSON data into DB table, and select them out through a simple left join query.
But I wanna know how to achieve that if I don't create a table for those static data.
mysql join
edited 14 mins ago
Andriy M
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
1
I have some static data which stored in a JSON file:
outinfo=
[{out_id:123,out_name:'hello'}]
and I have a table:
----tableA----
| id | label | out_id |
| 1 | a | 123 |
| 2 | b | 123 |
I wanna select all info out like
{id:1,label:"a",out_name:"hello"}
It is easy to achieve that by importing the outside JSON data into DB table, and select them out through a simple left join query.
But I wanna know how to achieve that if I don't create a table for those static data.
mysql join
edited 14 mins ago
Andriy M
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago
add a comment |
1
1
1
I have some static data which stored in a JSON file:
outinfo=
[{out_id:123,out_name:'hello'}]
and I have a table:
----tableA----
| id | label | out_id |
| 1 | a | 123 |
| 2 | b | 123 |
I wanna select all info out like
{id:1,label:"a",out_name:"hello"}
It is easy to achieve that by importing the outside JSON data into DB table, and select them out through a simple left join query.
But I wanna know how to achieve that if I don't create a table for those static data.
mysql join
edited 14 mins ago
Andriy M
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have some static data which stored in a JSON file:
outinfo=
[{out_id:123,out_name:'hello'}]
and I have a table:
----tableA----
| id | label | out_id |
| 1 | a | 123 |
| 2 | b | 123 |
I wanna select all info out like
{id:1,label:"a",out_name:"hello"}
It is easy to achieve that by importing the outside JSON data into DB table, and select them out through a simple left join query.
But I wanna know how to achieve that if I don't create a table for those static data.
mysql join
mysql join
edited 14 mins ago
Andriy M
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 14 mins ago
Andriy M
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 14 mins ago
Andriy M
16.3k63473
edited 14 mins ago
Andriy M
16.3k63473
edited 14 mins ago
Andriy M
16.3k63473
16.3k63473
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
asked Apr 19 at 3:42
Kent WoodKent Wood
1062
1062
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kent Wood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago
add a comment |
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Kent Wood is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f235243%2fis-there-a-way-to-let-mysql-join-some-external-data-without-importing-those-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Kent Wood is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Kent Wood is a new contributor. Be nice, and check out our Code of Conduct.
Kent Wood is a new contributor. Be nice, and check out our Code of Conduct.
Kent Wood is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f235243%2fis-there-a-way-to-let-mysql-join-some-external-data-without-importing-those-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
uli5FTk,1cB5HpM Cu7csW5IQniMTYD DHOI3G54dj,du64,tZVqPiR3B0mrl9nJBqsS7xcuqilSnZFXsYOaefoY11
No way. And no reasons for NOT import, especially when the data is static.
– Akina
Apr 19 at 5:15
You'll have to write a programme to do stuff like that!
– Vérace
2 days ago
yes,i was always vacillate in these little decitions. more left join always make me think things come more complex. but if i select the origin data out, then enhance them with other json data by outside program, the complex is apparent. so,i keep them in db at last.
– Kent Wood
2 days ago