title: Inserting SQLite primary key in python
body: <p>I am trying to do a SQLite insert from my python script. </p>
  
  <p>I am getting an error:</p>
  
  <pre><code>table history has 4 columns but 3 values were supplied
  </code></pre>
  
  <p>The reason there is 3 not 4, is that the first one is my ID. I assumed that as i declared it as a primary key it would auto-increment the value. How do I go about inserting the ID</p>
  
  <p>.py:</p>
  
  <pre><code>c.execute("INSERT INTO history VALUES (?,?,?)", (q[0],t,in))
  </code></pre>
  
  <p>.db</p>
  
  <pre><code>CREATE TABLE history (id integer primary key, employeeID integer, time datetime, inout varchar);
  </code></pre>