Mysql使用匹配值插入或更新一个表列数据到另一个表

Question

Iam bit new to Mysql, What is my question is, how to Update or Insert Table_1 column data to Table_2 column data with matching the relevant Id's from Table_1.

For Eg.

          Table_1                       Table_2                      

        rand  | cpn                   rand   |  cpn     
         1        4                     2        0
         2        7                     3        0
         3        2                     5        0
         4        1                     1        0
         5        7                     4        0

The above mentioned table are the current structure of the my tables, my output should be like this,

      Table_2

   rand   |  cpn     
     2        7
     3        2
     5        7
     1        4
     4        1 

I want to match the ids from table_1 and update in table_2, accordingly Thanks in Advance :)

Answer 1

In mysql you can use joins in updates to achive the expected results:

update table2 t2 inner join table1 t1 on t2.rand=t1.rand
set t2.cpn=t1.cpn