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; ``` ?
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; ``` ?