title: Python/mySQL : ProgrammingError: Not all parameters were used in the SQL statement
body: <p>I am using mysql 5.7.21,  Connector/Python 2.0.4, Python 3.6.3</p>
  
  <p>I defined a table in my python script, </p>
  
  <pre><code>TABLES['report'] = (
      "CREATE TABLE `report` ("
      "  `t` varchar(4) NOT NULL,"
      "  `s` varchar(50) NOT NULL,"
      "  `d` varchar(10) NOT NULL,"
      "  `v` int(12) NOT NULL,"
      "  `g` varchar(12) NOT NULL,"
      "  `q` varchar(12) NOT NULL,"
      "  PRIMARY KEY (`t`)"   
      ") ENGINE=InnoDB")
  </code></pre>
  
  <p>and have created it successfully in the db. </p>
  
  <p>But, when I tried to insert the following data </p>
  
  <pre><code>data= ('1111', 'xxxxxxxxxx-cc', 'AsOf20170630', '81785000', 'xxxx-cc', '2017Q2')
  </code></pre>
  
  <p>into table with </p>
  
  <pre><code>cursor.execute("INSERT INTO report (t, s, d, v, g, q) VALUES (%s, %s, %s, %s, %s, $s)", data)
  </code></pre>
  
  <p>I got an error, </p>
  
  <pre><code>ProgrammingError: Not all parameters were used in the SQL statement
  </code></pre>