mysql按分区查数据

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

SELECT * FROM logs PARTITION (p1);

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

SELECT * FROM logs WHERE log_date BETWEEN '2010-01-01' AND '2020-01-01';