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
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
edited Nov 10 at 14:47
Gordon Linoff
742k32285390
edited Nov 10 at 14:47
Gordon Linoff
742k32285390
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
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
742k32285390
answered Nov 10 at 14:46
Gordon Linoff
742k32285390
answered Nov 10 at 14:46
Gordon Linoff
742k32285390
answered Nov 10 at 14:46
Gordon Linoff
742k32285390
742k32285390
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
Required, but never shown
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
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
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