python对mysql查询更新_如何在python中用一个MySQL查询更新多行？

我不认为mysqldb可以同时处理多个更新查询。

但是，您可以在末尾使用带ON DUPLICATE KEY UPDATE条件的INSERT查询。

为了便于使用和阅读，我编写了下面的示例。import MySQLdb

def update_many(data_list=None, mysql_table=None):

"""

Updates a mysql table with the data provided. If the key is not unique, the

data will be inserted into the table.

The dictionaries must have all the same keys due to how the query is built.

Param:

data_list (List):

A list of dictionaries where the keys are the mysql table

column names, and the values are the update values

mysql_table (String):

The mysql table to be updated.

"""

# Connection and Cursor

conn = MySQLdb.connect('localhost', 'jeff', 'atwood', 'stackoverflow')

cur = conn.cursor()

query = ""

values = []

f