title: Is it possible to insert x number of default values into an empty SQLLite table in a single query?
body: <p>I would like to insert about <code>100,000</code> rows with <em>default values</em> into an SQLLite database and I want to make the engine work rather than iterating in a loop in Python. </p>
  
  <p>For <em>inserting with default values</em>, <a href="http://The%20third%20form%20of%20an%20INSERT%20statement%20is%20with%20DEFAULT%20VALUES.%20The%20INSERT%20...%20DEFAULT%20VALUES%20statement%20inserts%20a%20single%20new%20row%20into%20the%20named%20table.%20Each%20column%20of%20the%20new%20row%20is%20populated%20with%20its%20default%20value,%20or%20with%20a%20NULL%20if%20no%20default%20value%20is%20specified%20as%20part%20of%20the%20column%20definition%20in%20the%20CREATE%20TABLE%20statement.">the doc</a> has this to say:</p>
  
  <blockquote>
    <p>The third form of an INSERT statement is with DEFAULT VALUES. The INSERT ... DEFAULT VALUES statement <strong>inserts a single new row</strong> into the named table. Each column of the new row is populated with its default value, or with a NULL if no default value is specified as part of the column definition in the CREATE TABLE statement.</p>
  </blockquote>
  
  <p>That seems not be helpful, so I thought I could use <em>INSERT INTO ... SELECT</em>:</p>
  
  <blockquote>
    <p>The second form of the INSERT statement contains a SELECT statement instead of a VALUES clause. A new entry is inserted into the table for each row of data returned by executing the SELECT statement. If a column-list is specified, the number of columns in the result of the SELECT must be the same as the number of items in the column-list. Otherwise, if no column-list is specified, the number of columns in the result of the SELECT must be the same as the number of columns in the table. Any SELECT statement, including compound SELECTs and SELECT statements with ORDER BY and/or LIMIT clauses, may be used in an INSERT statement of this form.</p>
  </blockquote>
  
  <p>But, I can't figure out a way for making a select statement return <code>100,000</code> results on an empty table for use in an <code>INSERT INTO ... SELECT</code> statement. The docs on the <a href="https://www.sqlite.org/syntax/expr.html" rel="nofollow">SQLite expressions</a> haven't given me any clues.</p>
  
  <p>Is there a clever solution to this instead of brute forcing it with Python?</p>