SQL to insert or update (upsert)

INSERT INTO users (id, email, name)
VALUES (1, 'a@example.com', 'Ann')
ON CONFLICT (id) DO UPDATE
  SET email = EXCLUDED.email,
      name  = EXCLUDED.name;

EXCLUDED refers to the row you tried to insert.

INSERT INTO users (id, email, name)
VALUES (1, 'a@example.com', 'Ann')
ON DUPLICATE KEY UPDATE
  email = VALUES(email),
  name  = VALUES(name);

MERGE users AS target
USING (SELECT 1 AS id, 'a@example.com' AS email, 'Ann' AS name) AS src
ON target.id = src.id
WHEN MATCHED THEN
  UPDATE SET email = src.email, name = src.name
WHEN NOT MATCHED THEN
  INSERT (id, email, name) VALUES (src.id, src.email, src.name);