Mariadb(MySql)表横向RANGE分区

1.新建分区

ALTER TABLE table_name
PARTITION BY RANGE (column_name) (
	PARTITION p_name_0001 VALUES LESS THAN (column_value_range_1),
	PARTITION p_name_0002 VALUES LESS THAN (column_value_range_2),
	PARTITION p_name_0003 VALUES LESS THAN (column_value_range_3),
	PARTITION p_over VALUES LESS THAN MAXVALUE
);

2.向已有分区添加一个位于p_over之前的分区：

ALTER TABLE table_name 
REORGANIZE PARTITION p_over INTO (
	PARTITION p_name_0004 VALUES LESS THAN (column_value_range_4),
	PARTITION p_over VALUES LESS THAN MAXVALUE
);

3.删除一个分区：

ALTER TABLE table_name DROP PARTITION p_name;

4.把已有分区细分化重新分区：

ALTER TABLE table_name 
REORGANIZE PARTITION p_name_0001, p_name_0002, p_name_0003, p_name_0004,p_over INTO (
	PARTITION p_name_0001 VALUES LESS THAN (column_value_range_1),
	PARTITION p_name