Python executeemany()有关问题

Python executeemany()问题。

Python code

val=(['220521','1234567','1234567','13476123051','521','测试556','2','1','2','521','2012-04-10 00:00:00'],['220522','12345678','12345678','13476123052','测试557','1','1','2','522','2012-04-10 00:00:00']);
sql4="""insert into tdxtb_user values(%d,%s,%s,%d,%s,%s,%d,%d,%d,%s,%s)""";
cur.executemany(sql4,val)

返回错误：TypeError: int argument required
tdxtb_user表记录类型依次为 int char char bigint char varchar tinyint tinyint tinyint varchar datetime

是元组里的类型填错了还是其他问题？

------解决方案--------------------
全部用%s
------解决方案--------------------

探讨
Python code
val=(['220521','1234567','1234567','13476123051','521','测试556','2','1','2','521','2012-04-10 00:00:00'],['220522','12345678','12345678','13476123052','测试557','1','1','2','522','2012-04-10……

Python executeemany()有关问题

相关推荐