如何在给定的日期时间范围内创建日期表？

import datetime
import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

start_date = datetime.date(2022, 1, 1)
end_date = datetime.date(2022, 12, 31)

current_date = start_date
while current_date <= end_date:
    sql = "INSERT INTO date_table (date) VALUES (%s)"
    val = (current_date,)
    mycursor.execute(sql, val)
    current_date += datetime.timedelta(days=1)

mydb.commit()