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……

查看更多 下一篇