title: How to insert float numbers from mysqldump
body: <p>I have sql dump file coming from FirebirdSQL. Looks same as exported from MySQL (MariaDB). In the said file there are table creation statements one of which are the following:</p>
  
  <pre><code>CREATE TABLE VALIORS (
  ....,
      STK_SUM      FLOAT DEFAULT 0,
      TWO_PERC     FLOAT,
  ....,
  );
  </code></pre>
  
  <p>Later in the file are the following insert statements:</p>
  
  <pre><code>INSERT INTO VALIORS (...., SZK_ND,TWO_PERC, ....) values (...., 10039.349609375,200.78999328613281, ....);
  INSERT INTO VALIORS (...., SZK_ND,TWO_PERC, ....) values (...., 10039.349609375,200.78999328613281, ....);
  </code></pre>
  
  <p>The whole file is bigger than 500 MB, so I only import it through command line on windows machine with xampp installed.</p>
  
  <p>Everything else is imported correctly, but all float numbers are being rounded. My problem is I need them exact. Is there anyway to achieve it? And where the problem comes from?</p>