SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t1(id INT PRIMARY KEY, c TEXT);
✓
INSERT INTO t1(id, c) VALUES (1,'a'), (2, 'b');
✓
SELECT * FROM t1;


id
c


1
a

2
b


INSERT INTO t1(id, c) VALUES (1, 'c');
-- UNIQUE constraint failed: t1.id

{
  "code": "SQLITE_CONSTRAINT_PRIMARYKEY"
}


INSERT INTO t1(id, c) VALUES (1, 'c')
ON CONFLICT DO NOTHING;
✓
SELECT * FROM t1;


id
c


1
a

2
b


INSERT INTO t1(id, c)
VALUES (1, 'c')
ON CONFLICT(id) DO UPDATE SET c = excluded.c;
✓
SELECT * FROM t1;


id
c


1
c

2
b