Create Range Partition
CREATE TABLE <TB>(
...
CONSTRAINT <CSTRNT> PRIMARY KEY(<COL>, ...)
)
PARTITION BY RANGE(<RANGECOL>)
(
PARTITION <PTTN> VALUES LESS THAN (<VALUE>),
...
PARTITION <MAX_PTTN> VALUES LESS THAN (MAXVALUE)
);
CREATE TABLE <TB>(
...
CONSTRAINT <CSTRNT> PRIMARY KEY(<COL>, ...)
)
PARTITION BY RANGE(<RANGECOL>)
(
PARTITION <PTTN> VALUES LESS THAN (<VALUE>),
...
PARTITION <MAX_PTTN> VALUES LESS THAN (MAXVALUE)
);