mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
15 lines
340 B
Plaintext
15 lines
340 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);
|
|
|