title: Python 'float64' cannot be converted to a MySQL type but in manual query thats no problem
body: <p>I have python script and want insert data to database like this:</p>
  
  <pre><code>(1, -0.12301105260848999)
  (1, 0.07728659361600876)
  (1, 0.005048183258622885)
  (1, -0.03252531960606575)
  (1, -0.05449267476797104)
  (1, -0.026811596006155014)
  (1, 0.014027083292603493)
  (1, -0.10952591896057129)
  (1, 0.15669232606887817)
  (1, -0.04698480665683746)
  (1, 0.26182907819747925)
  (1, -0.015784427523612976)
  </code></pre>
  
  <p>And my table its ok, 
  <a href="https://i.stack.imgur.com/g7jhY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/g7jhY.png" alt="db"></a></p>
  
  <p>In that pict I try to manual insert data to db, and it's work fine. But in my python script return error:</p>
  
  <pre><code>Failed processing format-parameters; Python 'float64' cannot be converted to a MySQL type
  </code></pre>
  
  <p>I don't know what's wrong with that, because I insert manually and work. I used normal script to insert to db, here my script: </p>
  
  <pre><code>insert_encode_query = """INSERT INTO encoding_data
                              (id, face_encode)
                              VALUES (%s, %s)"""
  
      cursor = connection.cursor()
      cursor.executemany(insert_encode_query, detail_encoding)
      connection.commit()
  </code></pre>
  
  <p>Inside variable detail_encoding :</p>
  
  <pre><code>[(1, -0.12301105260848999), (1, 0.07728659361600876), (1, 0.005048183258622885), (1, -0.03252531960606575), (1, -0.05449267476797104), (1, -0.026811596006155014)]
  </code></pre>
  
  <p>What's wrong with my code, or how to convert to SQL type of float/decimal from python float64, or any solution for this? Thanks</p>