python executemany的使用_python之executemany使用

今天用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)