Help for this page

Select Code to Download

Select or download this

INSERT
  INTO records (PriKey, Foo, Bar)
  VALUES (1, 'Hello', World')
  ON DUPLICATE KEY
    UPDATE Foo=Foo;

Select or download this

INSERT
  INTO records (PriKey, Foo, Bar)
  VALUES (1, 'Hello', World')
  ON DUPLICATE KEY
    UPDATE Attempts=Attempts+1;