MYSQL 重复键更新问题

Question

当重复的主键已经在表中时，我正在尝试使用“ON DUPLICATE KEY UPDATE”语句来更新列。但即使表有重复的主键，它也不会更新列。

下面是“ON DUPLICATE KEY UPDATE”声明。有什么问题吗？

 ON DUPLICATE KEY UPDATE authenticated = authenticated
                  and notAuthenticated = notAuthenticated
                  and stoped = stoped
                  and deleted = deleted
                  and updatedDate = now()

;

Answer 1

使用 VALUES(Column) 并将所有 AND 替换为逗号 ,:

 ON DUPLICATE KEY UPDATE authenticated = VALUES(authenticated),
                  notAuthenticated = VALUES(notAuthenticated),
                  stoped = VALUES(stoped),
                  deleted = VALUES(deleted),
                  updatedDate = now()