python - 如何在 python 中使用单个 MySQL 查询更新多行？

Question

#!/usr/bin/python

# -*- coding: utf-8 -*-
import MySQLdb as mdb

con = mdb.connect('localhost', 'root', 'root', 'kuis')

with con:

    cur = con.cursor()
    cur.execute("UPDATE Writers SET Name = %s WHERE Id = %s ",
        ("new_value" , "3"))
    print "Number of rows updated:",  cur.rowcount

使用上面的代码，数据库 kuis 中表 Writers 的第三行的值被更新为 new_value 并且输出将是 Number od rows updated: 1
如何同时更新多行？

Answer 1

可能您正在寻找 cursor.executemany .

cur.executemany("UPDATE Writers SET Name = %s WHERE Id = %s ",
        [("new_value" , "3"),("new_value" , "6")])