Update table values from another table in sql
up vote
-1
down vote
favorite
I have a temporary table havinf 2 colums and i need to update this data into another table
Can Some one please help me with this
mysql sql
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla 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 |
up vote
-1
down vote
favorite
I have a temporary table havinf 2 colums and i need to update this data into another table
Can Some one please help me with this
mysql sql
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a temporary table havinf 2 colums and i need to update this data into another table
Can Some one please help me with this
mysql sql
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a temporary table havinf 2 colums and i need to update this data into another table
Can Some one please help me with this
mysql sql
mysql sql
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
edited Nov 10 at 14:47
Gordon Linoff
741k32285390
741k32285390
asked Nov 10 at 14:41
Anusha Kolla
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 10 at 14:41
Anusha Kolla
11
asked Nov 10 at 14:41
Anusha Kolla
11
11
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Anusha Kolla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42
add a comment |
1
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42
1
1
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You want to use join, something like this:
update othertable t join
temporarytable tt
on t.clientid = tt.clientid
set t.checklist = tt.checklist;
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You want to use join, something like this:
update othertable t join
temporarytable tt
on t.clientid = tt.clientid
set t.checklist = tt.checklist;
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
add a comment |
up vote
0
down vote
You want to use join, something like this:
update othertable t join
temporarytable tt
on t.clientid = tt.clientid
set t.checklist = tt.checklist;
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
add a comment |
up vote
0
down vote
up vote
0
down vote
You want to use join, something like this:
update othertable t join
temporarytable tt
on t.clientid = tt.clientid
set t.checklist = tt.checklist;
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
You want to use join, something like this:
update othertable t join
temporarytable tt
on t.clientid = tt.clientid
set t.checklist = tt.checklist;
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
answered Nov 10 at 14:46
Gordon Linoff
741k32285390
741k32285390
add a comment |
add a comment |
Anusha Kolla is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Anusha Kolla is a new contributor. Be nice, and check out our Code of Conduct.
Anusha Kolla is a new contributor. Be nice, and check out our Code of Conduct.
Anusha Kolla 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
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53240031%2fupdate-table-values-from-another-table-in-sql%23new-answer', 'question_page');
}
);
Post as a guest
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
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
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
1
Welcome to Stack Overflow! No images please. Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 10 at 14:42