mysql ÈçºÎºÏ²¢·ÖÇø£¿

SQL code:

ALTER TABLE tbl REORGANIZE PARTITION p_50000000 INTO
(
PARTITION p_50000000 VALUES LESS THAN (50000000),
PARTITION p_2008_12 VALUES LESS THAN (2307392000),
PARTITION p_2009_01 VALUES LESS THAN (2334176000),
PARTITION p_2009_02 VALUES LESS THAN (2358368000),
PARTITION p_2009_03 VALUES LESS THAN (2385152000),
PARTITION p_2009_04 VALUES LESS THAN (2411072000),
PARTITION p_2009_05 VALUES LESS THAN (2437856000)
);



ÎÒ´Ó·ÖÇøp_50000000Öл®·Ö³öÕâô¶à·ÖÇø£¬ÏÖÔÚºó»ÚÁË£¬Ï뽫ÕâЩ·ÖÇøºÏ²¢»Øp_50000000£¡

ÈçºÎ×öµ½£¿

---

ʾÀý£º
SQL code:
alter table tb_key_part11 reorganize partition p2,p3 into
(partition p3 values less than (30)
)

---

·Ö¼¸²½´¦Àí£º
SQL code:
ALTER TABLE tbl REORGANIZE PARTITION p_50000000,p_2008_12,p_2009_01,p_2009_02,p_2009_03,p_2009_04,p_2009_05 INTO
(
PARTITION p_2009_05 VALUES LESS THAN (2437856000)
);


ALTER TABLE tbl REORGANIZE PARTITION p_2009_05 into
(
PARTITION p_2009_05 VALUES LESS THAN (2437855000),
PARTITION p_50000000 VALUES LESS THAN (2437856000)
);

ALTER TABLE tbl REORGANIZE PARTITION