title: mySQL load data local infile incorrect number import operation
body: <p>I m trying to import data from a csv file to a database mysql that contains a column with type <code>float</code>. 
  So when i used the command  :</p>
  
  <pre><code>load DATA INFILE 'd:/dropbox/Dropbox/applications/glimp/f.csv' 
  INTO TABLE iot_dataa 
  FIELDS TERMINATED BY ';' 
  LINES TERMINATED BY '\n'
  (duration,date,fields1,fields2,fields3,fields4,rate,fields5,fields6,deviceid);
  </code></pre>
  
  <p>I got  the field with type float number with values of '0' in all lines.</p>
  
  <p>CSV file</p>
  
  <p><a href="https://i.stack.imgur.com/h71gQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h71gQ.png" alt="CSV  file"></a></p>
  
  <p>Table definition
  <a href="https://i.stack.imgur.com/szN90.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/szN90.png" alt="schema"></a></p>
  
  <p>mysql table
  <a href="https://i.stack.imgur.com/meOkh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/meOkh.png" alt="mysql table"></a></p>