How to insert data in a table using loop and columns are also dependent on other tables
0
In excel list I have
Member_number last_name Employer_name
34532 abc Company-A
48236 xyz company-b
82364 def company-c
74236 fjs company-d
32647 dgk company-e
732y6 yte company-A
y8ey4 uuu company-d
I need to insert data in a table which have below columns
employment_history_id = primary key
reference_id = SELECT member_id FROM mm_members WHERE member_number = '34532'
reference_type = 3
employer_id = SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%Company-A%' (Employer)
title =
month_from =
month_to =
year_from =
year_to =
is_currently_working =
I have tried below query and inserting successfully correa ct data but how can i use this query in loop which will insert data for all members in one time execution
INSERT INTO mm_employment_history(`employment_history_id`,`reference_id`,`reference_type`,`employer_id`,`title`,`month_from`,`month_to`,`year_from`,`year_to`,`is_currently_working`)
VALUES
(NULL,(SELECT member_id FROM mm_members WHERE member_number = '103'),'3',(SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%bar%'),'','0','0','0','0','0');
mysqli sqlyog
edited Nov 23 '18 at 13:24
xSavitar
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
add a comment |
0
In excel list I have
Member_number last_name Employer_name
34532 abc Company-A
48236 xyz company-b
82364 def company-c
74236 fjs company-d
32647 dgk company-e
732y6 yte company-A
y8ey4 uuu company-d
I need to insert data in a table which have below columns
employment_history_id = primary key
reference_id = SELECT member_id FROM mm_members WHERE member_number = '34532'
reference_type = 3
employer_id = SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%Company-A%' (Employer)
title =
month_from =
month_to =
year_from =
year_to =
is_currently_working =
I have tried below query and inserting successfully correa ct data but how can i use this query in loop which will insert data for all members in one time execution
INSERT INTO mm_employment_history(`employment_history_id`,`reference_id`,`reference_type`,`employer_id`,`title`,`month_from`,`month_to`,`year_from`,`year_to`,`is_currently_working`)
VALUES
(NULL,(SELECT member_id FROM mm_members WHERE member_number = '103'),'3',(SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%bar%'),'','0','0','0','0','0');
mysqli sqlyog
edited Nov 23 '18 at 13:24
xSavitar
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
add a comment |
0
0
0
In excel list I have
Member_number last_name Employer_name
34532 abc Company-A
48236 xyz company-b
82364 def company-c
74236 fjs company-d
32647 dgk company-e
732y6 yte company-A
y8ey4 uuu company-d
I need to insert data in a table which have below columns
employment_history_id = primary key
reference_id = SELECT member_id FROM mm_members WHERE member_number = '34532'
reference_type = 3
employer_id = SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%Company-A%' (Employer)
title =
month_from =
month_to =
year_from =
year_to =
is_currently_working =
I have tried below query and inserting successfully correa ct data but how can i use this query in loop which will insert data for all members in one time execution
INSERT INTO mm_employment_history(`employment_history_id`,`reference_id`,`reference_type`,`employer_id`,`title`,`month_from`,`month_to`,`year_from`,`year_to`,`is_currently_working`)
VALUES
(NULL,(SELECT member_id FROM mm_members WHERE member_number = '103'),'3',(SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%bar%'),'','0','0','0','0','0');
mysqli sqlyog
edited Nov 23 '18 at 13:24
xSavitar
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
In excel list I have
Member_number last_name Employer_name
34532 abc Company-A
48236 xyz company-b
82364 def company-c
74236 fjs company-d
32647 dgk company-e
732y6 yte company-A
y8ey4 uuu company-d
I need to insert data in a table which have below columns
employment_history_id = primary key
reference_id = SELECT member_id FROM mm_members WHERE member_number = '34532'
reference_type = 3
employer_id = SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%Company-A%' (Employer)
title =
month_from =
month_to =
year_from =
year_to =
is_currently_working =
I have tried below query and inserting successfully correa ct data but how can i use this query in loop which will insert data for all members in one time execution
INSERT INTO mm_employment_history(`employment_history_id`,`reference_id`,`reference_type`,`employer_id`,`title`,`month_from`,`month_to`,`year_from`,`year_to`,`is_currently_working`)
VALUES
(NULL,(SELECT member_id FROM mm_members WHERE member_number = '103'),'3',(SELECT company_id FROM mm_member_companies WHERE NAME LIKE '%bar%'),'','0','0','0','0','0');
mysqli sqlyog
mysqli sqlyog
edited Nov 23 '18 at 13:24
xSavitar
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
edited Nov 23 '18 at 13:24
xSavitar
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
edited Nov 23 '18 at 13:24
xSavitar
670623
edited Nov 23 '18 at 13:24
xSavitar
670623
edited Nov 23 '18 at 13:24
xSavitar
670623
670623
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
asked Nov 23 '18 at 12:51
HabibullahHabibullah
35
35
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f53447088%2fhow-to-insert-data-in-a-table-using-loop-and-columns-are-also-dependent-on-other%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
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53447088%2fhow-to-insert-data-in-a-table-using-loop-and-columns-are-also-dependent-on-other%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
