title: How do i insert 1000 times in one statement? with SQLITE?
body: <p>-edit- to make it more clear, i was just using a cmd line (actually ide in this case) and wanted to do quick testing with ram and didnt feel like making a full blown prj for a quick throwaway test.</p>
  
  <p>I want to fill this table with 10000000 values but first i want only 1000.</p>
  
  <p>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.</p>
  
  <pre><code>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
  </code></pre>