Example: Replacing rows
CREATE TABLE t(k INTEGER PRIMARY KEY, v);
INSERT INTO t(k, v) VALUES (1, 10);
INSERT OR REPLACE INTO t VALUES (1, 20);
SELECT * FROM t;
| k | v |
|---|---|
| 1 | 20 |
CREATE TABLE t(k INTEGER PRIMARY KEY, v);
INSERT INTO t(k, v) VALUES (1, 10);
INSERT OR REPLACE INTO t VALUES (1, 20);
SELECT * FROM t;
| k | v |
|---|---|
| 1 | 20 |