title: Not all parameters were used in the SQL statement when using python and mysql
body: <p>hi I am doing the python mysql at this project, I initial the database and try to create the table record, but it seems cannot load data to the table, can anyone here can help me out with this</p>
  
  <pre><code>import mysql.connector
  mydb = mysql.connector.connect( host="localhost",user="root",password="asd619248636",database="mydatabase")
  mycursor = mydb.cursor()
  mycursor.excute=("CREATE TABLE record (temperature FLOAT(20) , humidity FLOAT(20))")
  sql = "INSERT INTO record (temperature,humidity) VALUES (%d, %d)"
  val = (2.3,4.5)
  mycursor.execute(sql,val)
  mydb.commit()
  print(mycursor.rowcount, "record inserted.")
  </code></pre>
  
  <p>and the error shows     "Not all parameters were used in the SQL statement")
  mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement</p>