mysql按天生成表

import mysql.connector
from datetime import datetime, timedelta

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

# 获取当前日期并计算前一天的日期
today = datetime.now()
yesterday = today - timedelta(days=1)
table_name = f"logs_{yesterday.strftime('%Y%m%d')}"

# 创建新表
create_table_query = f"""
CREATE TABLE IF NOT EXISTS {table_name} (
    id INT AUTO_INCREMENT PRIMARY KEY,
    log_message TEXT NOT NULL,
    log_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
"""
cursor.execute(create_table_query)

# 插入示例数据
insert_query = f"INSERT INTO {table_name} (log_message) VALUES (%s)"
log_message = "Example log message"
cursor.execute(insert_query, (log_message,))

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