title: Adding row to Table - Primary Key/Auto Increment Error(System.Data.SQLite)
body: <p>I'm trying to insert a new row into a database which has four fields, the first is a primary key set as auto incrementing (integer) and the other three are strings. </p>
  
  <p>I insert a new with the following statement:</p>
  
  <blockquote>
    <p>INSERT INTO Manufacturer VALUES
    ('Test1','Test2','01332232321')</p>
  </blockquote>
  
  <p>But I am given the following exception:</p>
  
  <blockquote>
    <p>"SQLite error\r\ntable Manufacturer
    has 4 columns but 3 values were
    supplied"</p>
  </blockquote>
  
  <p>I assumed that the primary key field can be omitted as the database would automatically assign and increment the value for me.</p>
  
  <p>How would I go about fixing this? Is this a simple syntatical error or do I need to rethink my approach completely?</p>