mysql 5.5
CREATE TABLE PartitionTest1
(
pid INT NOT NULL AUTO_INCREMENT,
pname VARCHAR(100) NOT NULL,
ptime DATETIME NOT NULL,
PRIMARY KEY (ptime, pid)
)
ENGINE = MYISAM
PARTITION BY RANGE COLUMNS (ptime,pid)(
PARTITION PartitionTest_0 VALUES LESS THAN ('2014-04-01',1),
PARTITION PartitionTest_1 VALUES LESS THAN ('2014-05-01',5)
);
CREATE TABLE PartitionTest1
(
pid INT NOT NULL AUTO_INCREMENT,
pname VARCHAR(100) NOT NULL,
ptime DATETIME NOT NULL,
PRIMARY KEY (ptime, pid)
)
ENGINE = MYISAM
PARTITION BY RANGE COLUMNS (ptime,pid)(
PARTITION PartitionTest_0 VALUES LESS THAN ('2014-04-01',1),
PARTITION PartitionTest_1 VALUES LESS THAN ('2014-05-01',5)
);
通过执行查询索引的结果最准确show index from tableName
(
pid INT NOT NULL AUTO_INCREMENT,
pname VARCHAR(100) NOT NULL,
ptime DATETIME NOT NULL,
PRIMARY KEY (ptime, pid)
)
ENGINE = MYISAM
PARTITION BY RANGE(ptime)(
PARTITION p0 VALUES LESS THAN('2010'),
PARTITION p1 VALUES LESS THEN maxvalue
);
如果是这样,也还是只有一个全局索引吗?