title: Inserting empty string into auto_increment column in MySQL 5
body: <p>I've inherited a project which we are trying to migrate to MySQL 5 from MySQL 4.0(!) and from myISAM to InnoDB. Queries are now falling down because they are being constructed using an ADODB connection's ->qstr() on all parameters, including ints. Where no value is provided I end up with:</p>
  
  <pre><code>INSERT INTO tablename VALUES ('', 'stuff'...)
  </code></pre>
  
  <p>where the first column is an auto_increment. This causes an error (fair enough since '' isn't an int). Is there a switch in MySQL to make it behave as it used to (I assume it just silently converted to 0?)</p>