56,679
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE PartitionTest
(
pid INT NOT NULL AUTO_INCREMENT,
pname VARCHAR(100) NOT NULL,
ptime DATETIME NOT NULL,
PRIMARY KEY (ptime, pid)
)
ENGINE = MYISAM
PARTITION BY HASH(pid)
PARTITIONS 10;
CREATE TABLE PartitionTest
(
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
);
如果是这样,也还是只有一个全局索引吗?