mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 21:29:01 +00:00
12 lines
453 B
Plaintext
12 lines
453 B
Plaintext
|
|
CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID;
|
|
WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<10)
|
|
INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c;
|
|
CREATE INDEX t1a ON t1(a);
|
|
CREATE TABLE t2(x,y);
|
|
CREATE TABLE t3(cnt);
|
|
WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4)
|
|
INSERT INTO t3(cnt) SELECT i FROM c;
|
|
SELECT count(*) FROM t1;
|
|
|