title: Mysql ERROR 1136 (21S01): Column count doesn't match value count at row 1
body: <p>I have the following existing table in a mysql database: </p>
  
  <pre><code>+---------------------+---------------+------+-----+---------+----------------+
  | Field               | Type          | Null | Key | Default | Extra          |
  +---------------------+---------------+------+-----+---------+----------------+
  | f1                  | int(11)       | NO   | PRI | NULL    | auto_increment |
  | field2              | int(11)       | NO   | MUL | NULL    |                |
  | field3              | int(11)       | YES  |     | NULL    |                |
  | field4              | int(11)       | YES  |     | NULL    |                |
  | field6              | varchar(64)   | YES  |     | NULL    |                |
  | field7              | varchar(16)   | YES  |     | NULL    |                |
  | field8              | varchar(32)   | YES  |     | NULL    |                |
  | field9              | varchar(128)  | YES  |     | NULL    |                |
  | field10             | varchar(128)  | YES  |     | NULL    |                |
  | field11             | varchar(128)  | YES  |     | NULL    |                |
  | field12             | varchar(64)   | YES  |     | NULL    |                |
  | field13             | varchar(32)   | YES  |     | NULL    |                |
  | field14             | varchar(32)   | YES  |     | NULL    |                |
  | field15             | int(11)       | YES  | MUL | NULL    |                |
  | field16             | date          | YES  |     | NULL    |                |
  | field17             | date          | YES  |     | NULL    |                |
  | field18             | int(11)       | YES  | MUL | NULL    |                |
  | field19             | varchar(64)   | YES  |     | NULL    |                |
  | field20             | varchar(64)   | YES  |     | NULL    |                |
  | field21             | varchar(16)   | YES  |     | NULL    |                |
  | field22             | varchar(20)   | YES  |     | NULL    |                |
  | field23             | varchar(1000) | YES  |     | NULL    |                |
  | field24             | int(11)       | NO   | MUL | NULL    |                |
  | field25             | int(11)       | NO   |     | 0       |                |
  | field26             | decimal(19,2) | YES  |     | 0.00    |                |
  | field27             | decimal(19,2) | YES  |     | 0.00    |                |
  | field28             | int(11)       | YES  | MUL | NULL    |                |
  | field29             | int(11)       | YES  | MUL | NULL    |                |
  | field30             | varchar(128)  | YES  |     | NULL    |                |
  | field31             | varchar(128)  | YES  |     | NULL    |                |
  | field32             | varchar(16)   | YES  |     | NULL    |                |
  | field33             | int(11)       | YES  |     | NULL    |                |
  | field34             | int(11)       | YES  |     | NULL    |                |
  | field35             | varchar(128)  | YES  |     | NULL    |                |
  | field36             | int(11)       | YES  | MUL | NULL    |                |
  | field37             | int(11)       | YES  |     | NULL    |                |
  +---------------------+---------------+------+-----+---------+----------------+
  </code></pre>
  
  <p>I try the following statement to add another row and I'm getting the following error: </p>
  
  <pre><code>ERROR 1136 (21S01): Column count doesn't match value count at row 1
  </code></pre>
  
  <p>Here are the ways I've tried to insert the row into the table:</p>
  
  <pre><code>insert into table (Field, Type, Null, Key, Default, Extra) VALUES ("contract_expiration", "date", "YES", "", "NULL", "");
  
  insert into table VALUES ('contract_expiration','date','YES','','NULL','');
  </code></pre>
  
  <p>Both return the same error.  There are no triggers on the table, I'm not sure what's going on. </p>
  
  <p>Any suggestions?  I'm relatively new to mysql administration, I know a bit but this has me stumped and searches for solutions have turned up nothing.  </p>
  
  <p>Any help that could be provided would be MUCH appreciated!</p>