从一个csv更新多个表，并在update_or_insert之后获取行id

import csv
import MySQLdb

# 1. 解析CSV文件
data = []
with open('data.csv', 'r') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        data.append(row)

# 2. 连接数据库
conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database')
cursor = conn.cursor()

# 3. 更新多个表
for row in data:
    # 更新表1
    sql1 = "UPDATE table1 SET column1 = %s WHERE column2 = %s"
    cursor.execute(sql1, (row['value1'], row['value2']))

    # 更新表2
    sql2 = "UPDATE table2 SET column3 = %s WHERE column4 = %s"
    cursor.execute(sql2, (row['value3'], row['value4']))

    # ...

    # 提交事务
    conn.commit()

    # 4. 获取行ID
    row_id = cursor.lastrowid
    print("Inserted/updated row ID:", row_id)

# 关闭数据库连接
cursor.close()
conn.close()