title: LOAD DATA INFILE (*.csv) - ignore empty cells
body: <p>I'm about to import a large (500 MB) *.csv file to a MySQL database.</p>
  <p>I'm as far as that:</p>
  <pre><code>LOAD DATA INFILE '&lt;file&gt;'
      REPLACE
      INTO TABLE &lt;table-name&gt;
      FIELDS
          TERMINATED BY ';'
          OPTIONALLY ENCLOSED BY '&quot;'
      IGNORE 1 LINES ( #Header
          &lt;column-name1&gt;,
          &lt;column-name2&gt;,
          ...
      );
  </code></pre>
  <p>I have a problem with one of the coluns (it's data type is int) - I get an error Message:</p>
  <blockquote>
  <p>Error Code: 1366 Incorrect integer value: ' ' for column  at row </p>
  </blockquote>
  <p>I looked at this line in the *.csv-file. The cell that causes the error has just a whitespace inside (like this: ...; ;...).</p>
  <p>How can I tell SQL to ignore whitespaces in this column?</p>
  <p>As the *.csv-file is very big and I have to import even bigger ones afterwards, I'd like to avoid editing the *.csv-file; I'm looking for a SQL-solution.</p>