1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(10)) PARTITION BY RANGE (c1) (
3 PARTITION p0 VALUES LESS THAN (100),
4 PARTITION p1 VALUES LESS THAN (200),
5 PARTITION p2 VALUES LESS THAN (300),
6 PARTITION p3 VALUES LESS THAN (400),
7 PARTITION p4 VALUES LESS THAN (500),
8 PARTITION p5 VALUES LESS THAN MAXVALUE);
12 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
13 SELECT * FROM t1 ORDER BY c1;
22 t1 CREATE TABLE `t1` (
23 `c1` int(11) NOT NULL,
24 `c2` char(10) DEFAULT NULL,
26 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
27 /*!50100 PARTITION BY RANGE (c1)
28 (PARTITION p0 VALUES LESS THAN (100) ENGINE = ENGINE,
29 PARTITION p1 VALUES LESS THAN (200) ENGINE = ENGINE,
30 PARTITION p2 VALUES LESS THAN (300) ENGINE = ENGINE,
31 PARTITION p3 VALUES LESS THAN (400) ENGINE = ENGINE,
32 PARTITION p4 VALUES LESS THAN (500) ENGINE = ENGINE,
33 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
34 ALTER TABLE t1 REBUILD PARTITION p1,p2;
35 SELECT * FROM t1 ORDER BY c1;
44 t1 CREATE TABLE `t1` (
45 `c1` int(11) NOT NULL,
46 `c2` char(10) DEFAULT NULL,
48 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
49 /*!50100 PARTITION BY RANGE (c1)
50 (PARTITION p0 VALUES LESS THAN (100) ENGINE = ENGINE,
51 PARTITION p1 VALUES LESS THAN (200) ENGINE = ENGINE,
52 PARTITION p2 VALUES LESS THAN (300) ENGINE = ENGINE,
53 PARTITION p3 VALUES LESS THAN (400) ENGINE = ENGINE,
54 PARTITION p4 VALUES LESS THAN (500) ENGINE = ENGINE,
55 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */