Insert multiple rows in single query and update existing

Question

Is it possible to insert multiple rows in single query but in the same time check if record exist and update existing record?

I have to avoid REPLACE INTO because my table have primary and unique keys.

Answer 1

I'm not sure where to put ON DUPLICATE KEY in my query?

insert into mytable (A, B C) values 
('a','b',1),
('c','d',2),
('e','f',3) ON DUPLICATE KEY UPDATE A = VALUES(A), B = VALUES(B), C = VALUES(C)

This is solution:

insert into mytable (A, B C) values 
('a','b',1),
('c','d',2),
('e','f',3) ON DUPLICATE KEY UPDATE A = VALUES(A), B = VALUES(B), C = VALUES(C)

Thanks to all!