Re: Help with "ON DUPLICATE KEY UPDATE"

[Rick James]

INSERT INTO ... (..., pdr, ...) VALUES (..., pdr, ...)
SELECT ..., SUM(pdr) AS pdr, ... FROM ... GROUP BY ...
ON DUPLICATE KEY UPDATE pdr = VALUES(pdr);