mysql - 从 JOIN Shows #1064 更新表

Question

我正在尝试执行此操作

  UPDATE product
SET Product_entr_notes = t2.note
    ,Product_entr_email = t2.email
    ,Product_entr_mobile = t2.Mobile
    ,Product_entr_phone = t2.Home_Phone
FROM product AS t1
INNER JOIN result AS t2 ON t1.id = t2.ACTID

但我越来越

1064 - 您的 SQL 语法有错误；检查与您的 MariaDB 服务器版本相对应的手册，以在第 1 行的“FROM product t1 INNER JOIN result t2 ON t1.id = t2.ACTID WHERE t1.id = t2.ACTID”附近使用正确的语法

标签： mysqlsql-update

Answer 1

您应该紧跟JOIN在 之后Update，例如：

UPDATE product t1
INNER JOIN result AS t2 ON t1.id = t2.ACTID
SET Product_entr_notes = t2.note
    ,Product_entr_email = t2.email
    ,Product_entr_mobile = t2.Mobile
    ,Product_entr_phone = t2.Home_Phone