可能您正在寻找cursor.executemany。
cur.executemany("UPDATE Writers SET Name = %s WHERE Id = %s ",
[("new_value" , "3"),("new_value" , "6")])
如何在python中使用单个MySQL查询更新多行?
可能您正在寻找cursor.executemany。
cur.executemany("UPDATE Writers SET Name = %s WHERE Id = %s ",
[("new_value" , "3"),("new_value" , "6")])