mysql依据时间分区表

CREATE TABLE orders (
    id INT AUTO_INCREMENT,
    order_number VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    total_amount DECIMAL(10, 2),
    PRIMARY KEY (id, created_at)
) PARTITION BY RANGE (TO_DAYS(created_at)) (
    PARTITION p202201 VALUES LESS THAN (TO_DAYS('2022-02-01')),
    PARTITION p202202 VALUES LESS THAN (TO_DAYS('2022-03-01')),
    PARTITION p202203 VALUES LESS THAN (TO_DAYS('2022-04-01')),
    PARTITION p202204 VALUES LESS THAN (TO_DAYS('2022-05-01')),
    PARTITION p202205 VALUES LESS THAN (TO_DAYS('2022-06-01')),
    PARTITION p202206 VALUES LESS THAN (TO_DAYS('2022-07-01')),
    PARTITION p202207 VALUES LESS THAN (TO_DAYS('2022-08-01')),
    PARTITION p202208 VALUES LESS THAN (TO_DAYS('2022-09-01')),
    PARTITION p202209 VALUES LESS THAN (TO_DAYS('2022-10-01')),
    PARTITION p202210 VALUES LESS THAN (TO_DAYS('2022-11-01')),
    PARTITION p202211 VALUES LESS THAN (TO_DAYS('2022-12-01')),
    PARTITION p202212 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION pmax VALUES LESS THAN MAXVALUE
);