如何按不在唯一索引中的列对MySQL表进行分区

CREATE TABLE sales (
    id INT NOT NULL,
    date DATE NOT NULL,
    product VARCHAR(50),
    quantity INT,
    price DECIMAL(10,2)
)
PARTITION BY RANGE (TO_DAYS(date)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2021-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2021-02-01')),
    PARTITION p2 VALUES LESS THAN (TO_DAYS('2021-03-01')),
    PARTITION p3 VALUES LESS THAN (TO_DAYS('2021-04-01')),
    PARTITION p4 VALUES LESS THAN (MAXVALUE)
);