duandang6111 2016-02-19 10:47
浏览 329
已采纳

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

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 :)

  • 写回答

4条回答 默认 最新

  • douya1061 2016-02-19 10:54
    关注

    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 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?