通过从两个表连接来更新所有字段值

I have two MySQL tables:

我有两个MySQL表:

  Table items            Table buffer
---------------         -------------
id     keywords         id      value
1      val1             1       val2
2      val1             2       val2
3      val1             3       val2
  Tabl