> >INSERT INTO t1 SELECT 1 UNION SELECT 2 UNION (...) SELECT 9999; > >It works out of the box on any DBMS you care to name, and of course in >SQLite, too. It is ever so slightly verbose, but better than the >alternative of executing 9999 INSERT INTO t1 VALUES(###); >
Of course, if your objective is just to have a table with a wholenumber sequence of rows, you could use the wholenumber virtual table extension: CREATE VIRTUAL TABLE nums USING wholenumber; SELECT value FROM nums WHERE value<10000; SELECT value FROM nums WHERE value BETWEEN 100 AND 500; wholenumber.c is part of the sqlite distribution in ext/misc under the source tree ... _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
