title: SQLite3: Python Input to Table - Trouble with Auto Increment
body: <p>I am currently having an issue with importing data to a sqlite3 table.
  In my TEST program, users input their <em>fake</em> information when asked for an input.
  I then take that input and put it in my Table, however, I am having an issue with the AutoIncrementing "User ID". Each user gets their own ID, and so far there are 5 users. When a new User inputs their data, how do I make it so it automatically sets "UserID" to the next number, in this case 6.</p>
  
  <p>Everything works if I manually put "6" in the first Value (in the following code), but how do I make that automatic?</p>
  
  <pre><code>conn = sqlite3.connect('xxxxxxx.db')
  c=conn.cursor()
  NameCreate = input("Please enter your First and Last name: ")
  UserNameCreate = input("Please enter your desired User Name: ")
  PasswordCreate = input("Please enter your desired Password: ")
  DOBCreate = input("Please enter your date of birth [DD.MM.YYYY]: ")
  FavouriteArtistCreate = input("Please enter your favourite Arist: ")
  FavouriteGenreCreate = input("Please enter your favourite Genre: ")
  
  c.execute("INSERT INTO Users VALUES (AUTOINCREMENT, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}')".format(NameCreate, DOBCreate, UserNameCreate, PasswordCreate, FavouriteArtistCreate, FavouriteGenreCreate))
  conn.commit()
  </code></pre>