使用Python列表MySQL更新Col值

Question

我在下面给出的代码中阅读了一列的长度。然后，我有一个列表fakenames其长度等于列的原始长度。

如何用我的列表fakenames值替换原始列person_names的值？更改应反映在数据库中。

import MySQLdb

# Connect
db = MySQLdb.connect(
  host="abc.us-east-1.rds.amazonaws.com",
  user="abc",
  password="password",
)

cursor = db.cursor()

# Execute SQL select statement
cursor.execute("SELECT COUNT(person_names) FROM z3_table")
number_of_names = (cursor.fetchone()[0])

print(number_of_names)

fakeNames = []

# Commit your changes if writing
# In this case, we are only reading data
# db.commit()

# Close the connection
db.close()

这意味着从列表中的每个值fakenames都应在其他行中。