title: Why does Table Import is showing error 1366, Data looks good
body: <p>I exported data from a view in my workbench to upload this data into my new table on other database, but when I try to upload this data I am getting this error below: </p>
  
  <pre><code>- Row import failed with error: ("Incorrect integer value: '' for column 'id_genero_musical' at row 1", 1366
  </code></pre>
  
  <p>What I did change this value '' to NULL, but when I put NULL value on CSV file, it is showing:</p>
  
  <pre><code>- Row import failed with error: ("Incorrect integer value: 'NULL' for column 'id_genero_musical' at row 1", 1366
  </code></pre>
  
  <p>But my file there is NO quotes, my file is as lines below:</p>
  
  <pre><code>4,"Cultura",NULL,"FM",102.5,0,NULL,NULL,"http://www.cultura.fm.br/","",NULL,16,"PR",2969,"Cultura",5,NULL
  6,"Abdallah",NULL,"FM",104.1,55,NULL,NULL,"http://www.abdallahfm.com.br/","http://server3.webradios.com.br:9338/9338","57dbac33ef411",16,"PR",2911,"Abdallah",5,3
  7,"Aline",NULL,"FM",93.7,0,NULL,NULL,"http://www.alinefm.com.br","http://controleflash.omegasistemas.net:8356/;stream.mp3","57dbac367dbbc",16,"PR",3147,"Aline",5,3
  8,"Amiga",NULL,"FM",101.3,40,NULL,NULL,"http://www.amiga101.com.br","http://stream4.painelvox.com.br:7052","57dbac337965d",16,"PR",2878,"Amiga",5,3
  9,"Caiuá",NULL,"FM",103.5,80,NULL,NULL,"http://www.caiuafm.com.br/","http://stream1.painelvox.com.br:6946/","57dbac352b125",16,"PR",3015,"Caiuá",5,1
  </code></pre>
  
  <p>I am using import button on MySQL Workbench and the database is MariaDB</p>
  
  <p>I spent 2 or 3 days trying to solve that, without success, please help me.</p>
  
  <p>Thank you guys!!</p>
  
  <p>Edit 1:</p>
  
  <p>Workbench is assuming that NULL value is a text, not a NULL value, how can I handle that to import a CSV file assuming that it is a real NULL value?</p>