INSERT... ON DUPLICATE KEY UPDATE not working as I expect
Well this is the insert bit that you are using:


  INSERT INTO example (a, b, c) VALUES (1,2,3) ....


here you are not specifying the id (the primary key to be checked for duplication). Since, it is set to auto-increment, it automatically sets the id for the next row with just the values for columns a, b and c.

The row in this case is updated when you provide a primary key (that you want to check is duplicate or not), along with the rest of the row data.
If you need to check and update according to record id, you have to provide the KEY as well, which in your case is id.

Try something like this:

INSERT INTO example (id, a, b, c) VALUES (1,1,2,3) ON DUPLICATE KEY UPDATE a = VALUES(a), b = VALUES(b), c = VALUES(c);


Now if, the id is duplicate, the row will update.