SQLite Forum

Insert within CTE
Login
Do you mean something like:

```
create table t(x);
WITH RECURSIVE
cnt(x) AS (
 SELECT 1
 UNION ALL
 SELECT x+1 FROM cnt
  LIMIT 1000000
)
INSERT INTO t SELECT x FROM cnt;
```
?