mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-05-29 20:03:34 +00:00
8 lines
178 B
Plaintext
8 lines
178 B
Plaintext
|
|
||
|
|
-- create a table with many entries
|
||
|
|
CREATE TABLE t1(x);
|
||
|
|
WITH RECURSIVE
|
||
|
|
c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
|
||
|
|
INSERT INTO t1 SELECT x FROM c;
|
||
|
|
|