mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
20 lines
345 B
Plaintext
20 lines
345 B
Plaintext
|
|
CREATE TABLE t1(x, y, UNIQUE(x, y));
|
|
INSERT INTO t1 VALUES('one', 'two');
|
|
SELECT * FROM t1 WHERE x='one';
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
SELECT * FROM t1 WHERE x='one';
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
CREATE TABLE t1(a, b);
|
|
CREATE INDEX i1 ON t1(a, b);
|
|
|
|
|
|
PRAGMA page_size = 4096;
|
|
CREATE TABLE t1(a, b);
|
|
CREATE INDEX i1 ON t1(a, b);
|
|
|