How do i insert 1000 times in one statement? with SQLITE?
Posted
by acidzombie24
on Stack Overflow
See other posts from Stack Overflow
or by acidzombie24
Published on 2010-05-21T20:13:17Z
Indexed on
2010/05/21
20:20 UTC
Read the original article
Hit count: 121
sqlite
I want to fill this table with 10000000 values but first i want only 1000.
I tried this in sqlite database browser but 3 isnt inserted unless i drop everything after it. But more importantly i dont know how to have num go from 1 to 1000.
create table if not exists test1(id integer primary key, val integer);
insert into test1(val) select '3' as num where num between 1 and 1000
© Stack Overflow or respective owner