python 往mysql中批量插入数据

1、可以批量插入[(value1,value2),(value3,value4)]  列表中是元组类型

2、可以批量插入[[value1,value2],[value3,value4]]  列表中是列表类型

fields = ['a', 'b']
sql = "insert into test2 ({fields}) values ({mark})".format(
    fields='`' + '`,`'.join(fields) + '`',
    mark=','.join(['%s'] * len(fields))
)
temp_list = [[6, 7], [72, 8], [37, 87]]
temp_list = [(1, 2), (2, 3), (3, 4)]
conn = connect()
with conn.cursor() as cur:
    cur.executemany(sql, temp_list)
    conn.commit()
cur.close()
conn.close()