mysql每天创建一张表

CREATE TABLE IF NOT EXISTS logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    message TEXT NOT NULL,
    log_date DATE NOT NULL
) PARTITION BY RANGE (TO_DAYS(log_date)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2023-02-01')),
    PARTITION p2 VALUES LESS THAN (TO_DAYS('2023-03-01')),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

#!/bin/bash

today=$(date +%Y-%m-%d)
table_name="logs_$today"

sql="CREATE TABLE IF NOT EXISTS $table_name (
    id INT AUTO_INCREMENT PRIMARY KEY,
    message TEXT NOT NULL,
    log_date DATE NOT NULL
);"

mysql -u username -p password -e "$sql"