mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-14 04:25:16 +00:00
15 lines
337 B
Plaintext
15 lines
337 B
Plaintext
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES(1, NULL);
|
|
INSERT INTO t1 VALUES(2, NULL);
|
|
INSERT INTO t1 VALUES(1, NULL);
|
|
|
|
SELECT DISTINCT x, y FROM t1
|
|
CREATE UNIQUE INDEX i1 ON t1(x, y)
|
|
SELECT DISTINCT x, y FROM t1
|
|
|
|
CREATE TABLE t2(x, y NOT NULL);
|
|
CREATE UNIQUE INDEX t2x ON t2(x);
|
|
CREATE UNIQUE INDEX t2y ON t2(y);
|
|
|