参考如下语句进行创建

CREATE TABLE order_history

(id int, order_date date, amount decimal(10,2))

PARTITION BY RANGE(order_date)

(

PARTITION p01 VALUES LESS THAN ('2020-01-01'),

PARTITION p02 VALUES LESS THAN ('2020-02-01'),

PARTITION p03 VALUES LESS THAN (MAXVALUE)

);