title: Default value for empty integer fields when importing CSV data in MySQL
body: <p>I'm importing a CSV into a MySQL table with <code>LOAD DATA INFILE</code>. One of the table's fields stores zip code data, which I've defined in the table structure <code>contributor_zipcode INT</code>.</p>
  
  <p>In the CSV, this field is sometimes empty. When I execute the <code>LOAD</code> query, MySQL will throw a warning like:</p>
  
  <p><code>Incorrect integer value: '' for column 'contributor_zipcode' at row 180</code></p>
  
  <p>I've tried redefining the field as <code>contributor_zipcode INT DEFAULT '0'</code>, which creates the same warning, and <code>contributor_zipcode INT DEFAULT NULL</code>, which MySQL won't allow. Any advice?</p>