mysql 递增插入日期

CREATE TABLE logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    message VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO logs (message) VALUES ('Log message 1');
INSERT INTO logs (message) VALUES ('Log message 2');

import mysql.connector
from datetime import datetime, timedelta

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 插入数据
for i in range(5):
    created_at = datetime.now() + timedelta(days=i)
    sql = "INSERT INTO logs (message, created_at) VALUES (%s, %s)"
    val = ("Log message " + str(i+1), created_at)
    cursor.execute(sql, val)

db.commit()
cursor.close()
db.close()