Answers for "how to get id of last updated record when using on duplicate key update in mysql"

mysql on duplicate key update

INSERT INTO t1 (a,b,c) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE c=3;
INSERT INTO t1 (a,b,c) VALUES (4,5,6)
  ON DUPLICATE KEY UPDATE c=9;

Posted by: Guest on October-28-2020

Code answers related to "how to get id of last updated record when using on duplicate key update in mysql"