title: with mysql load data infile I get "incorrect integer value"
body: <pre><code>LOAD DATA INFILE 'thefile.csv' 
  INTO TABLE word 
  FIELDS TERMINATED BY ';'
  IGNORE 1 LINES
  SET id = NULL;
  </code></pre>
  
  <p>I am a bit lost of what to do here, I thought this query would work but it doesn't. I get the error about id, which is why I thought set id = NULL would make it good but no. The point of my id row (which is AUTO_INCREMENT) is that I don't need to specify the ID. so.. ehm. Any help would be greatly appreciated </p>
  
  <pre><code>Incorrect integer value: '' for column 'id' at row 1 
  </code></pre>
  
  <p>My CSV file content:</p>
  
  <pre><code>id;meaning;japanese;kanji;kana;romaji;visible;featured;image;image_author;imgauthor_link;extra
  ;pants;パンツ;;パンツ;pantsu;;;;;;
  </code></pre>