mysql 分区清空

CREATE TABLE logs (
    id INT AUTO_INCREMENT,
    log_date DATE,
    message TEXT,
    PRIMARY KEY (id, log_date)
) PARTITION BY RANGE (YEAR(log_date)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

ALTER TABLE logs DROP PARTITION p1;

-- 创建分区表
CREATE TABLE logs (
    id INT AUTO_INCREMENT,
    log_date DATE,
    message TEXT,
    PRIMARY KEY (id, log_date)
) PARTITION BY RANGE (YEAR(log_date)) (
    PARTITION p0 VALUES LESS THAN (2020),
    PARTITION p1 VALUES LESS THAN (2021),
    PARTITION p2 VALUES LESS THAN (2022),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

-- 插入示例数据
INSERT INTO logs (log_date, message) VALUES
('2020-01-01', 'Log message 1'),
('2021-01-01', 'Log message 2'),
('2022-01-01', 'Log message 3');

-- 清空分区 p1
ALTER TABLE logs DROP PARTITION p1;