typeerror mysql_python mysql使用executemany()出现TypeError

def insertData(self,table,param):

try:

self.db.set_character_set('utf8')

q= []

for x in param:

cols = ', '.join(x.keys())

values = '"," '.join(x.values())

q.append((table, cols, '"'+values+'"'))

sql = "INSERT INTO %s(%s) VALUES(%s)"

try:

result = self.cur.executemany(sql,q)

insert_id = self.db.insert_id()

self.db.commit()

except MySQLdb.Error,e:

#发生错误时回滚

self.db.rollback()

except MySQLdb.Error,e:

print self.getCurrentTime(),"数据库错误，原因%d: %s" % (e.args[0], e.args[1])

其中q的部分内容为[('houseurl', 'url', u'"/ershoufang/szlh11469938.html"'), ('houseurl', 'url', u'"/ershoufang/szlh11470634.html"')]

执行以上代码后，出现以下问题：

29 sql = "INSERT INTO %s(%s) VALUES(%s)"

30 try:

---> 31 result = self.cur.executemany(sql,q)

32 insert_id = self.db.insert_id()

33 self.db.commit()

/usr/lib/python2.7/dist-packages/MySQLdb/cursors.pyc in executemany(self, query, args)

274 self.errorhandler(self, ProgrammingError, msg.args[0])

275 else:

--> 276 self.errorhandler(self, TypeError, msg)

277 except (SystemExit, KeyboardInterrupt):

278 raise

/usr/lib/python2.7/dist-packages/MySQLdb/connections.pyc in defaulterrorhandler(***failed resolving arguments***)

34 del connection

35 if isinstance(errorvalue, BaseException):

---> 36 raise errorvalue

37 if errorclass is not None:

38 raise errorclass(errorvalue)

TypeError: not all arguments converted during string formatting

但是我一条条插入使用execute()就没问题。