根据同一列中的一列，用来自另一张表的数据更新一个表中的行 [英] Update rows in one table with data from another table based on one column in each being equal

问题描述

根据每个列中的一列相等(user_id)，将 许多行 从另一个表更新为一个表.

Update many rows into one table from another table based on one column in each being equal (user_id).

两个表都有一个user_id列.当user_id列相等时，需要将t2中的数据插入到t1中.

both tables have a user_id column. Need to insert data from t2 into t1 when the user_id column are equal.

在此先感谢您提供的帮助.

Thank you in advance for any help offered.

推荐答案

update 
  table1 t1
set
  (
    t1.column1, 
    t1.column2
      ) = (
    select
      t2.column1, 
      t2.column2
    from
      table2  t2
    where
      t2.column1 = t1.column1
     )
    where exists (
      select 
        null
      from 
        table2 t2
      where 
        t2.column1 = t1.column1
      );

或者这样(如果t2.column1< => t1.column1是多对一的，并且其中任何一个都是好人):

Or this (if t2.column1 <=> t1.column1 are many to one and anyone of them is good):

update 
  table1 t1
set
  (
    t1.column1, 
    t1.column2
      ) = (
    select
      t2.column1, 
      t2.column2
    from
      table2  t2
    where
      t2.column1 = t1.column1
    and
      rownum = 1    
     )
    where exists (
      select 
        null
      from 
        table2 t2
      where 
        t2.column1 = t1.column1
      ); 

这篇关于根据同一列中的一列，用来自另一张表的数据更新一个表中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！