Inserting data from frontend in foreign key through query
0
I'm trying to pass the data (post method) from Angular to Postgresql via Nodejs. How to insert foreign key value from frontend (dynamically) in insert query ?
query1:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('abc',
(SELECT id_teacher FROM tab_teacher WHERE id_teacher_pk = ? )
//how do we get the foreign key id_teacher_fk from frontend
query 2:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('rich man', LAST_INSERT_ID())
sql postgresql
asked Nov 21 '18 at 11:19
GMBGMB
196
add a comment |
0
I'm trying to pass the data (post method) from Angular to Postgresql via Nodejs. How to insert foreign key value from frontend (dynamically) in insert query ?
query1:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('abc',
(SELECT id_teacher FROM tab_teacher WHERE id_teacher_pk = ? )
//how do we get the foreign key id_teacher_fk from frontend
query 2:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('rich man', LAST_INSERT_ID())
sql postgresql
asked Nov 21 '18 at 11:19
GMBGMB
196
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
1
There is nolast_insert_id()in Postgres. Are you looking forlastval()?
– a_horse_with_no_name
Nov 21 '18 at 11:36
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04
add a comment |
0
0
0
I'm trying to pass the data (post method) from Angular to Postgresql via Nodejs. How to insert foreign key value from frontend (dynamically) in insert query ?
query1:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('abc',
(SELECT id_teacher FROM tab_teacher WHERE id_teacher_pk = ? )
//how do we get the foreign key id_teacher_fk from frontend
query 2:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('rich man', LAST_INSERT_ID())
sql postgresql
asked Nov 21 '18 at 11:19
GMBGMB
196
I'm trying to pass the data (post method) from Angular to Postgresql via Nodejs. How to insert foreign key value from frontend (dynamically) in insert query ?
query1:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('abc',
(SELECT id_teacher FROM tab_teacher WHERE id_teacher_pk = ? )
//how do we get the foreign key id_teacher_fk from frontend
query 2:
INSERT INTO tab_student (name_student, id_teacher_fk)
VALUES ('rich man', LAST_INSERT_ID())
sql postgresql
sql postgresql
asked Nov 21 '18 at 11:19
GMBGMB
196
asked Nov 21 '18 at 11:19
GMBGMB
196
edited Nov 21 '18 at 11:30
GMB
asked Nov 21 '18 at 11:19
GMBGMB
196
asked Nov 21 '18 at 11:19
GMBGMB
196
asked Nov 21 '18 at 11:19
GMBGMB
196
196
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
1
There is nolast_insert_id()in Postgres. Are you looking forlastval()?
– a_horse_with_no_name
Nov 21 '18 at 11:36
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04
add a comment |
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
1
There is nolast_insert_id()in Postgres. Are you looking forlastval()?
– a_horse_with_no_name
Nov 21 '18 at 11:36
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
1
1
There is no
last_insert_id() in Postgres. Are you looking for lastval()?– a_horse_with_no_name
Nov 21 '18 at 11:36
There is no
last_insert_id() in Postgres. Are you looking for lastval()?– a_horse_with_no_name
Nov 21 '18 at 11:36
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04
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%2f53410991%2finserting-data-from-frontend-in-foreign-key-through-query%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%2f53410991%2finserting-data-from-frontend-in-foreign-key-through-query%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
@wildplasser how do I insert the value into foreign key from frontend ,should I use "INSERT INTO emp (name,id) values ('abc',LAST_INSERT_ID())" ?
– GMB
Nov 21 '18 at 11:33
1
There is no
last_insert_id()in Postgres. Are you looking forlastval()?– a_horse_with_no_name
Nov 21 '18 at 11:36
What information does the frontend have on the teacher? Is the teacher allready present in the tab_teachers table?
– wildplasser
Nov 21 '18 at 11:51
frontend on teacher : teacher_id ,name , designation department . frontend on student : stud_id ,name,class (At the backend teacher_id is a foreign key in student table how could i update teacher_id in student table ? )
– GMB
Nov 21 '18 at 12:04