mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
8 lines
192 B
Plaintext
8 lines
192 B
Plaintext
|
|
CREATE TABLE t1(a);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
|
|
INSERT INTO t1(a) SELECT x FROM c;
|
|
CREATE TABLE empty(x);
|
|
SELECT count(*) FROM t1;
|
|
|