How to use ON DUPLICATE KEY for multiple entries?

Question

In a single entry, we can use ON DUPLICATE KEY to UPDATE the value:

INSERT INTO table
(title, number) VALUES ('$title', '$amount')
ON DUPLICATE KEY UPDATE number=number+$amount

How to use `ON DUPLICATE KEY for multiple entries as

INSERT INTO table
(title, number) VALUES 
('$title1', '$amount1'), 
('$title2', '$amount2'),
('$title3', '$amount3')
.....

Answer 1

You can use the values clause:

ON DUPLICATE KEY UPDATE 
   number = values(number),
   title = values(title)