title: Incorrect decimal (integer) value: ' ' mySQL
body: <p>In mySQL workbench database, one of the tables has latitude, longitude and district attributes </p>
  
  <p>lat: decimal (10,8)</p>
  
  <p>lng: decimal (11,8)</p>
  
  <p>district: int(4)</p>
  
  <p>I'm trying to import data from .csv file to this table</p>
  
  <pre><code>ERROR 1366: 1366: Incorrect decimal value: '' for column 'lat' at row 1
  SQL Statement:
  ERROR 1366: 1366: Incorrect integer value: '' for column 'district' at row 1
  SQL Statement:
  INSERT INTO `db`.`myTable` (`id`, `name_en`, `icon`, `lat`, `lng`, `district`, `city`, `postal_code`)
      VALUES ('686', 'Name',?, '', '', '','1', 'P.O. Box 1111')
  </code></pre>