How do i insert 1000 times in one statement? with SQLITE?
- by acidzombie24
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
