1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY RANGE (c1) (
3 PARTITION p0 VALUES LESS THAN (1991),
4 PARTITION p1 VALUES LESS THAN (1995),
5 PARTITION p2 VALUES LESS THAN (1999),
6 PARTITION p3 VALUES LESS THAN (2002),
7 PARTITION p4 VALUES LESS THAN (2006),
8 PARTITION p5 VALUES LESS THAN MAXVALUE);
14 t1 CREATE TABLE `t1` (
15 `c1` smallint(6) DEFAULT NULL,
16 `c2` int(11) DEFAULT NULL
17 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
18 /*!50100 PARTITION BY RANGE (c1)
19 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = ENGINE,
20 PARTITION p1 VALUES LESS THAN (1995) ENGINE = ENGINE,
21 PARTITION p2 VALUES LESS THAN (1999) ENGINE = ENGINE,
22 PARTITION p3 VALUES LESS THAN (2002) ENGINE = ENGINE,
23 PARTITION p4 VALUES LESS THAN (2006) ENGINE = ENGINE,
24 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
28 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY RANGE (c1) (
29 PARTITION p0 VALUES LESS THAN (1991),
30 PARTITION p1 VALUES LESS THAN (1995),
31 PARTITION p2 VALUES LESS THAN (1999),
32 PARTITION p3 VALUES LESS THAN (2002),
33 PARTITION p4 VALUES LESS THAN (2006),
34 PARTITION p5 VALUES LESS THAN MAXVALUE);
40 t1 CREATE TABLE `t1` (
41 `c1` mediumint(9) DEFAULT NULL,
42 `c2` int(11) DEFAULT NULL
43 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
44 /*!50100 PARTITION BY RANGE (c1)
45 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = ENGINE,
46 PARTITION p1 VALUES LESS THAN (1995) ENGINE = ENGINE,
47 PARTITION p2 VALUES LESS THAN (1999) ENGINE = ENGINE,
48 PARTITION p3 VALUES LESS THAN (2002) ENGINE = ENGINE,
49 PARTITION p4 VALUES LESS THAN (2006) ENGINE = ENGINE,
50 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
54 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY RANGE (c1) (
55 PARTITION p0 VALUES LESS THAN (1991),
56 PARTITION p1 VALUES LESS THAN (1995),
57 PARTITION p2 VALUES LESS THAN (1999),
58 PARTITION p3 VALUES LESS THAN (2002),
59 PARTITION p4 VALUES LESS THAN (2006),
60 PARTITION p5 VALUES LESS THAN MAXVALUE);
66 t1 CREATE TABLE `t1` (
67 `c1` int(11) DEFAULT NULL,
68 `c2` int(11) DEFAULT NULL
69 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
70 /*!50100 PARTITION BY RANGE (c1)
71 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = ENGINE,
72 PARTITION p1 VALUES LESS THAN (1995) ENGINE = ENGINE,
73 PARTITION p2 VALUES LESS THAN (1999) ENGINE = ENGINE,
74 PARTITION p3 VALUES LESS THAN (2002) ENGINE = ENGINE,
75 PARTITION p4 VALUES LESS THAN (2006) ENGINE = ENGINE,
76 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
80 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY RANGE (c1) (
81 PARTITION p0 VALUES LESS THAN (1991),
82 PARTITION p1 VALUES LESS THAN (1995),
83 PARTITION p2 VALUES LESS THAN (1999),
84 PARTITION p3 VALUES LESS THAN (2002),
85 PARTITION p4 VALUES LESS THAN (2006),
86 PARTITION p5 VALUES LESS THAN MAXVALUE);
92 t1 CREATE TABLE `t1` (
93 `c1` int(11) DEFAULT NULL,
94 `c2` int(11) DEFAULT NULL
95 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
96 /*!50100 PARTITION BY RANGE (c1)
97 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = ENGINE,
98 PARTITION p1 VALUES LESS THAN (1995) ENGINE = ENGINE,
99 PARTITION p2 VALUES LESS THAN (1999) ENGINE = ENGINE,
100 PARTITION p3 VALUES LESS THAN (2002) ENGINE = ENGINE,
101 PARTITION p4 VALUES LESS THAN (2006) ENGINE = ENGINE,
102 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */
106 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY RANGE (c1) (
107 PARTITION p0 VALUES LESS THAN (1991),
108 PARTITION p1 VALUES LESS THAN (1995),
109 PARTITION p2 VALUES LESS THAN (1999),
110 PARTITION p3 VALUES LESS THAN (2002),
111 PARTITION p4 VALUES LESS THAN (2006),
112 PARTITION p5 VALUES LESS THAN MAXVALUE);
116 SHOW CREATE TABLE t1;
118 t1 CREATE TABLE `t1` (
119 `c1` bigint(20) DEFAULT NULL,
120 `c2` int(11) DEFAULT NULL
121 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
122 /*!50100 PARTITION BY RANGE (c1)
123 (PARTITION p0 VALUES LESS THAN (1991) ENGINE = ENGINE,
124 PARTITION p1 VALUES LESS THAN (1995) ENGINE = ENGINE,
125 PARTITION p2 VALUES LESS THAN (1999) ENGINE = ENGINE,
126 PARTITION p3 VALUES LESS THAN (2002) ENGINE = ENGINE,
127 PARTITION p4 VALUES LESS THAN (2006) ENGINE = ENGINE,
128 PARTITION p5 VALUES LESS THAN MAXVALUE ENGINE = ENGINE) */