根据行将数据从一列插入另一个MYSQL

Question

I am new to MYSQL queries so I am struggling with this.

I have two tables

Table 1 

  id       phone1  phone2   name     ...
  1        123      456
  3        234      567
  7        345      678

Table 2

  id        p1        p2    age     ...
  1        1123      2456
  7        1345      2678
  3        1234      2567

ID is the same for both tables. Both tables have many other rows.

I want to copy the data from Table 2 to Table 1 such that the id stays the same.

So the output should be

Table 1 
  id       phone1  phone2   name
  1        1123      2456
  3        1234      2567
  7        1345      2678

Answer 1

Already answered :

stackoverflow

In your case :

UPDATE table1 t1
    INNER JOIN table2 t2 ON t2.id = t1.id
    SET t1.phone1 = t2.p1,
    t1.phone2 = t2.p2;