Up: SQLite [Top][Contents]
CREATE TABLE t(v, singleton BOOL UNIQUE DEFAULT TRUE CHECK(singleton = TRUE)); INSERT INTO t(v) VALUES (10); INSERT OR REPLACE INTO t(v) VALUES (20); SELECT * FROM t;