今天用python连接mysql数据库,在插入多条数据的时候，有个语法一直不会用，就是executeman，args参数的格式其实是一个元祖，其他格式都不行
具体代码如下：
def insertMore(self,condition,params):
try:
self.cur.executemany(condition,params)
self.conn.commit()
return True
exceptpymysql.Errorase:
print("Mysql Error %d:%s"%(e.args[0],e.args[1]))
logging.basicConfig(filename=os.path.join(os.getcwd(),'./log.txt'),
level= logging.DEBUG,
format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s')
logger = logging.getLogger(__name__)
logger.exception(e)
return False
if__name__=="__main__":
test = OperationDb_interface()#实例化类
错误用法
#result = test.insertMore('INSERT INTO student values(8,"aaa")，param=xxx')
正确用法
result = test.insertMore('INSERT INTO student values(%s,%s)',params=[(9,"ab"),(6,"abcd"),(7,"abcde")])
print(result)
