python mysql：虽然%s和列匹配，但并非SQL语句中使用的所有参数

Question

PythonMySQL.connector一直给我错误不是SQL语句中使用的所有参数。这是我的代码：

import mysql.connector

con = mysql.connector.Connect(user='root', password='password', database='DB', host='localhost')
cur = con.cursor()

#data inserter
add_data = "INSERT INTO DB.verkiezing (jaar, kamer, opkomst1, opkomst2, thema, gemeente, provincie, winnaar, VVD, PvdA, PVV, SP, CDA, D66, ChristenUnie, GROENLINKS, SGP, PvdD, 50Plus, OndernemersPartij, VNL, Denk, NieuweWegen, FvD) VALUES ($s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s, $s)"

#data
testvar = ('2017', "'Tweede", '81.9', '85.8', 'Identiteit', "'s-Gravenhage", 'Zuid-Holland', 'VVD', '33.0', '9.0', '20.0', '14.0', '19.0', '19.0', '5.0', '14.0', '3.0', '5.0', '4.0', '0.0', '0.0', '0.0', '0.0', '3.0')

cur.execute(add_data, testvar)
con.commit()

cur.close()
con.close()

即使%s的数目和列数匹配，仍会弹出错误。如果我尝试在MySQL中执行相同的操作，比如：

^{pr2}$

它很管用，没问题。我在Python中做错了什么？我使用python3.6.1和MySQL 14.14发行版5.7.14。提前谢谢你