mysql动态创建月表

import mysql.connector
from datetime import datetime

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

cursor = db.cursor()

# 获取当前月份
current_month = datetime.now().strftime("%Y-%m")

# 表名
table_name = f"logs_{current_month}"

# 创建表的SQL语句
create_table_sql = 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
)
"""

# 执行SQL语句
cursor.execute(create_table_sql)

# 提交更改
db.commit()

# 关闭连接
cursor.close()
db.close()