title: Mysql with Python can't insert record with autoincrement id, why?
body: <p>I create a table 'test' with two column:(age int, name TEXT) in mysql database.</p>
  
  <p>Then I insert a record using the following codes(with a list): </p>
  
  <pre><code>record = [12, 'Tom']
  cursor.execute("insert into test values(%s,%s)", record)
  </code></pre>
  
  <p>The above codes work in mysql(I use python 2.7 for programming).</p>
  
  <p>I then delete the old table and want to add an AUTO_INCREMENT P_id field for the new table, by adding the following code to the CREATE TABLE sql:</p>
  
  <pre><code>P_id int(11) PRIMARY KEY AUTO_INCREMENT,
  </code></pre>
  
  <p>And the new table works and I find it in mysql.
  However, when I try to insert a new record using the same codes:</p>
  
  <pre><code>record = [12, 'Tom']
  cursor.execute("insert into test values(%s,%s)", record)
  </code></pre>
  
  <p>But it doesn't work and reports:</p>
  
  <pre><code>OperationalError: (1136, "Column count doesn't match value count at row 1")
  </code></pre>
  
  <p>It looks like I should add the value of P_id by myself?
  But should it increase automatically and I can omit that?
  I'm quite a newbie in mysql and please help with details.</p>
  
  <p>This is my first time question in StackOverflow and thanks for any help.</p>