mysql 按月建表

CREATE TABLE user_login_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    login_time DATETIME NOT NULL,
    ip_address VARCHAR(50),
    login_result ENUM('success', 'failure')
) PARTITION BY RANGE (TO_DAYS(login_time)) (
    PARTITION p202301 VALUES LESS THAN (TO_DAYS('2023-02-01')),
    PARTITION p202302 VALUES LESS THAN (TO_DAYS('2023-03-01')),
    PARTITION p202303 VALUES LESS THAN (TO_DAYS('2023-04-01')),
    -- 继续添加其他月份的分区
    PARTITION p_max VALUES LESS THAN MAXVALUE
);

-- 插入数据
INSERT INTO user_login_log (user_id, login_time, ip_address, login_result)
VALUES (1, '2023-01-15 10:00:00', '192.168.1.1', 'success');

-- 查询2023年1月的登录记录
SELECT * FROM user_login_log PARTITION (p202301);