title: Is there AUTO INCREMENT in SQLite?
body: <p>I am trying to create a table with an auto-incrementing <code>primary key</code> in <a href="https://www.sqlite.org/index.html" rel="noreferrer">Sqlite3</a>.  I am not sure if this is really possible, but I am hoping to only have to designate the other fields.</p>
  
  <p>For example:</p>
  
  <pre><code>CREATE TABLE people (id integer primary key auto increment, first_name varchar(20), last_name varchar(20));
  </code></pre>
  
  <p>Then, when I add a value, I was hoping to only have to do:</p>
  
  <pre><code>INSERT INTO people
  VALUES ("John", "Smith");
  </code></pre>
  
  <p>Is this even possible?</p>
  
  <p>I am running <code>sqlite3</code> under <code>cygwin</code> in Windows 7.</p>