php - MySQL ON 重复键语法错误

Question

我正在尝试通过 PHP 使用“ON DUPLICATE KEY”查询。这是它的样子

INSERT INTO `application`.`invites` (`from`, `to`) VALUES ('123', '321') ON DUPLICATE KEY UPDATE `from`=VALUES(from), `to`=VALUES(to)

我做错了什么？

#1064 - 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), `to`=VALUES(to)' at line 1 

Answer 1

您需要在 from 和 to 周围加上反引号，无论您在哪里使用它们:

INSERT INTO `application`.`invites` (`from`, `to`)
    VALUES ('123', '321')
    ON DUPLICATE KEY UPDATE `from` = VALUES(`from`), `to` = VALUES(`to`)

事实上，这些对于列来说都是非常糟糕的名称。您应该避免使用保留字作为列名。