MYSQL 更新子句比较 2 个表中的 WHERE

Question

$produpd = "UPDATE tblnavpc SET tblnavpc.ChildName = tblnav.NavName " .
    "FROM tblnav WHERE tblnavpc.CID = tblnav.NavID";

这是我得到的错误”

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM tblnav WHERE tblnavpc.CID = tblnav.NavID' at line 1

我知道键的命名并不好，但我只是想解决这个问题，我没有命名表。

Answer 1

更新中没有 FROM 子句:

UPDATE tblnavpc
INNER JOIN tblnav ON tblnavpc.CID = tblnav.NavID
SET tblnavpc.ChildName = tblnav.NavName