title: How to correctly set AUTO INCREMENT fo a column in SQLite, using Python?
body: <p>I have been trying with the below code:</p>
  
  <pre><code>import sqlite3
  data_person_name = [('Michael', 'Fox'),
                      ('Adam', 'Miller'),
                      ('Andrew', 'Peck'),
                      ('James', 'Shroyer'),
                      ('Eric', 'Burger')]
  con = sqlite3.connect(":memory:")
  c = con.cursor()
  c.execute('''CREATE TABLE q1_person_name
               (name_id integer auto_increment primary key,
                first_name varchar(20) NOT NULL,
                last_name varchar(20) NOT NULL)''')
  c.executemany('INSERT INTO q1_person_name VALUES (?,?,?)', data_person_name)
  for row in c.execute('SELECT * FROM q1_person_name'):
      print row
  </code></pre>
  
  <p>Can somebody help me in making the <code>name_id</code> automatically incremented ? </p>