使用两个日期之间的随机日期时间更新每一行

import random
from datetime import datetime, timedelta

start_date = datetime(2022, 1, 1)  # 起始日期
end_date = datetime(2022, 12, 31)  # 结束日期

# 生成随机日期时间
random_date = start_date + timedelta(seconds=random.randint(0, int((end_date - start_date).total_seconds())))

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 查询表格中的所有行
query = "SELECT * FROM table_name"
cursor.execute(query)
rows = cursor.fetchall()

# 更新每一行的日期时间字段
for row in rows:
    random_date = start_date + timedelta(seconds=random.randint(0, int((end_date - start_date).total_seconds())))
    update_query = "UPDATE table_name SET datetime_column = %s WHERE id = %s"
    cursor.execute(update_query, (random_date, row[0]))

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()