title: Objective-c FMDB SQLite insert withParameterDictionary and auto-increment key
body: <p>I have an iOS app using FMDB library.</p>
  
  <p>There is a 7 field SQLite DB (1 autoincrement, 6 regular text fields).</p>
  
  <p>I am trying to execute </p>
  
  <pre><code> [db executeUpdate:@"INSERT INTO messages  VALUES (:field1,:field2,:field3,:field4,:field5,:field6)" withParameterDictionary:message];
  </code></pre>
  
  <p>However because there are only 6 fields I get an error. I cannot insert the autoincrement value, since I do not know what it is (I guess I could put a separate query for that...). And I am trying to avoid injection-susceptible syntax</p>
  
  <pre><code>NSString* sql = [NSString stringWithFormat:@"insert into messages (%@) values (%@)", [newCols componentsJoinedByString:@", "], [newVals componentsJoinedByString:@", "]];
  </code></pre>
  
  <p>Thank you for advice!</p>