title: Simple SQL Lite table/import question
body: <p>I have a simple SQL question. I want to make a 3 column database and I have the following code:</p>
  
  <pre><code>sqlite3 meshdb.db "create table t1 (t1key INTEGER PRIMARY KEY, prideID, pubmedID);"
  </code></pre>
  
  <p>When I try to import a simple csv file with two columns (prideID and pubmedID), I get a "expected 3 columns of data but found 2" error. I want the t1key to be an integer, and automatically count up as new fields are added. Do I have to put NOT NULL in front of PRIMARY KEY to for this to work?</p>