There are two tables t1 and t2.

t1

  |  user_id |  nick |  message | 
 |  - | user_1 |  text |
 |  - | user_2 |  text |

t2

  |  user_id |  nick | 
  |  23 | user_1 |
  |  45 | user_2 |

How to create a query to fill the user_id column in t1 using t2 data? Thank.

    1 answer 1

    Like so

    update t1 inner join t2 on t1.nick = t2.nick set t1.user_id = t2.user_id