title: node js and mysql convert number with comma to float
body: <p>i have a json Array which contains parsed numbers (in this Format: 12345,012) I want to save it to my mySQL db table. </p>
  
  <p>Right now my function insert the number to my table like this => 12345.000.</p>
  
  <p>my query looks like that:</p>
  
  <pre><code>connection.query('INSERT INTO mytable SET ?', jsonArray, callback);
  </code></pre>
  
  <p>So what should I change? My jsonArray contains numbers so I cannot .replace the comma to dot.</p>
  
  <pre><code>My jsonArray:             My Table:              I want this Values:
  12345,012                  12345.000              12345.012
  23456,123                  23456.000              23456.123
  </code></pre>
  
  <p>Edit: My table columns are = <strong>float(20,5)</strong></p>
  
  <p>Edit2: The json Array is an object :</p>
  
  <pre><code>{ id: 'kdsnad0123',
    value1: '0',
    value2: '0',
    value3: '251,4331',
    value4: '5,51135',
    value5: '6,74677',
    value6: '110'
  }{ id: 'kdsnad0124',
    value1: '10',
    value2: '660',
    value3: '251,4331',
    value4: '4,4235',
    value5: '3,727',
    value6: '10'
  }...
  </code></pre>
  
  <p>comming from a csv file and inserted with an foreach to my table:</p>
  
  <pre><code>  async.forEach(jsonArrayObject, function (jsonArray, callback) {
             conn.query('INSERT INTO mytable SET ?', jsonArray, callback);
             console.log(jsonArray);
  </code></pre>