Insert into table without all values
<p>Specifically, how would I insert into sqlite3 database and python without using all the values.</p>

<p>If my table is setup like this:</p>

<pre><code>People:    
f_name | l_name | age | favorite_color
</code></pre>

<p>When I create a new row, how would I be able to only put in a few values like this:</p>

<pre><code>c.execute("INSERT INTO People VALUES (?, ?)", (f_name, l_name))
</code></pre>

<p>Right now it would give an error for only filling two of the four columns.</p>

<p>You'll have to list the columns explicitly:</p>

<p><code>c.execute("INSERT INTO People (f_name, l_name) VALUES (?, ?)", (f_name, l_name))</code></p>

python sqlite3