pyodbc executemany 报错:The SQL contains 0 parameter markers, but 3 parameters were supplied‘, ‘HY000‘
sql = r'INSERT INTO test (id, name, salesrep) VALUES (%s, %s, %s)'vals = [('1', 'John Smith', 'John Doe'), ('2', 'Jane Doe', 'Joe Dog'), ('3', 'Mike T.', 'Sarah H.')]cursor.executemany(sql, vals)
原创
2021-06-04 21:34:33 ·
2381 阅读 ·
0 评论