Update Relational table based on another table in MySQL

Question

I have two table TABLE1 and TABLE2. Now I want to update value in relational table(TABLE2) with matching a ID of Master table(TABLE1) with another table ID and take value from that another table and update into that relational table.

How can i do this?

TABLE1

ID    
NAME

TABLE2

AUTO_ID 
ID
VALUE
LANGUAGE_ID

Now, I have same tables like

TABLE1_OLD

ID
NAME

TABLE2_OLD

AUTO_ID
ID
VALUE
LANGUAGE_ID

So I want to do is, want to take LANGUAGE_ID 2 value from old table and update into new one depend on ID matched.

Can you give a concrete example with table structures and what exactly you're trying to achieve? It's a bit hard to follow the question, worded as it is. — Mureinik, Oct 21 '14 at 06:28
Are you aware that every table in a relational database is a "relational" table? Not sure what you mean with the term "relational table" — , Oct 21 '14 at 06:35

Sadikhasan · Answer 1 · 2014-10-21T06:55:50.787

0

UPDATE table2 set table2.language_id = your_value_here
WHERE table1.id = table2.id;

edited Oct 21 '14 at 06:55

answered Oct 21 '14 at 06:36

Sadikhasan

18,365
21
80
122

table1 is not have language_id field – Bhumi Shah Oct 21 '14 at 06:36
what you want from table1? – Sadikhasan Oct 21 '14 at 06:45

Update Relational table based on another table in MySQL

1 Answers1

Linked