python_executemany遇到问题
在运行以下代码时:
def executemany(self, infolist):
param = [infolist[i] for i in xrange(len(infolist))]
sql = "insert into spidertable(ip, human_probability, crawler_probability, badman_probability) values (%d, %s, %s, %s)"
self._cur.executemany(sql, param)
self._con.commit()
遇到问题:
File "/home/ivan/my_github/holmes/src/database.py", line 82, in executemany
self._cur.executemany(sql,param)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 222, in executemany
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ValueError: unsupported format character ',' (0x2c) at index 3
我不知道该如何解决,是版本的问题么?
[解决办法]
你这和你的SQL里的明显对不上啊,SQL里的四个,第一个整型,后面的三个字符串,你传的参数不是
[解决办法]
第一个参数应该是带格式化的sql语句吧,第二个才是数据参数...