在python中使用pyodbc库插入到

Question

我尝试在Python中使用pyodbc将一些值导入到sqlserverdb中。在

for data_form in data['matches']:
    connprod = pyodbc.connect('Driver={ODBC Driver 13 for SQL Server};Server=tcp:*****.database.windows.net,1433;Database=League_Stats;Uid=******;Pwd=******;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;')
    cursorprod = connprod.cursor() 
    lane= str(data_form['lane'])
    gameId= str(data_form['gameId'])
    champion= int(data_form['champion'])
    platformId= str(data_form['platformId'])
    timestamp= str(data_form['timestamp'])
    queue= str(data_form['queue'])
    role= str(data_form['role'])
    season= str(data_form['season'])


UPDATE_SQL = """\
    INSERT INTO MATCH_HISTORY_LIST
        (lane, gameId, champion, platformId, timestamp, queue, role, season)
    VALUES
        (?,?,?,?,?,?,?,?,)
"""

print '--------------'
print "INSERT INTO Match_History_List(lane, gameId, champion, platformId, timestamp, queue, role, season) VALUES(?,?,?,?,?,?,?,?,)", lane,gameId,champion,platformId,timestamp,queue,role,season
cursorprod.execute(UPDATE_SQL, (lane,gameId,champion,platformId,timestamp,queue,role,season))
cnxn.commit()

这是我得到的错误：

^{pr2}$

我不知道)来自哪里。我尝试过打印语句并手动在数据库上运行它，它成功地工作了。在