对于给定的表数据范围自动生成分区的语法是:
PARTITION BY <RANGE> ([ColumnName] <NULLS LAST | NULLS FIRST> ,...) ( STARTING <FROM> [Start | MINVALUE | MAXVALUE] | STARTING <FROM> ([Start | MINVALUE | MAXVALUE] ,...) <INCLUSIVE | EXCLUSIVE> ENDING <AT> [End | MINVALUE | MAXVALUE] | ENDING <AT> ([End | MINVALUE | MAXVALUE] ,...) <INCLUSIVE | EXCLUSIVE> EVERY <(>[Constant] <DurationLabel> <)> ,...)
手工指定分区的语法是:
PARTITION BY <RANGE> ([ColumnName] <NULLS LAST | NULLS FIRST> ,...) ( <PARTITION [PartitionName]> STARTING <FROM> [Start | MINVALUE | MAXVALUE] | STARTING <FROM> ([Start | MINVALUE | MAXVALUE] ,...) <INCLUSIVE | EXCLUSIVE> ENDING <AT> [End | MINVALUE | MAXVALUE] | ENDING <AT> ([End |