python中使用excutemany执行update语句，批量更新

当一次性需要批量更新许多数据时，这时需要使用excutemany()函数可以更快速地将数据更新到数据库，

如下程序示范了如何使用excutemany执行 update 语句：

# coding:utf8
import pymysql
import logging

connection = pymysql.connect(host=HOST, port=3306, user=USER, password=PASSWORD,                        
               db=DATABASE,charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
cursor = connection.cursor()
flag_List = ["A", "B", "C", "D"]  # 存储flage的值
id_list = ["1", "2", "3", "4"]  # 存储id的值
commit_id_list = [(flag_List[i], id_list[i]) for i in range(len(id_list))]  
# commit_id_list必须是list[tuple(),tuple()...]或tuple(tuple(),tuple()...)的形式

with connection.cursor() as cursor:
    try:
        sql = "update mydatabase SET flag=(%s) where id=(%s)"
        cursor.executemany(sql, commit_id_list)  # commit_id_list上面已经说明
        connection.commit()
    except:
        logging.exception("exception")
        connection.rollback()
connection.close()

同理，excutemany()使用insert和delete语句是一样的！使用excutemany来代替excute，可以更快速地执行数据库操作，并且更加方便！