我有一个表，我想翻译一行的“topic”和“review”列，并将整个表及其翻译存储到一个新表中。似乎for循环没有遍历输入表的所有行。只有第一行存储到新表中。为什么？

database = mysql.connector.connect(user='root', password='root', host='localhost', database='test')

DBcursor = database.cursor(buffered=True)

query = ("SELECT * FROM test_de")

DBcursor.execute(query)

for (id, user_name, date, country, version, score, topic, review, url) in DBcursor:

    topic_trans = translate(topic, 'en')
    review_trans = translate(review, 'en')

    add_translation = ("INSERT INTO test_de_en(id, user_name, date, country, version, score, topic, review, url)"

                            "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)")

    translation_data = (id, user_name, date, country, version, score, topic_trans, review_trans, url)

    DBcursor.execute(add_translation, translation_data)

    database.commit()

DBcursor.close()

database.close()

字符串