56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `businesslog` (
`UserId` VARCHAR(300) COLLATE utf8_bin NOT NULL,
`ServiceId` VARCHAR(300) COLLATE utf8_bin NOT NULL,
`CreatedDateTime` DATETIME NOT NULL
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
PARTITION BY RANGE (YEAR(`CreatedDateTime`))
(PARTITION p0 VALUES LESS THAN (2000) ENGINE = MYISAM,
PARTITION p1 VALUES LESS THAN (2001) ENGINE = MYISAM,
PARTITION p2 VALUES LESS THAN (2002) ENGINE = MYISAM,
PARTITION p3 VALUES LESS THAN (2003) ENGINE = MYISAM,
PARTITION p4 VALUES LESS THAN (2004) ENGINE = MYISAM,
PARTITION p5 VALUES LESS THAN (2005) ENGINE = MYISAM,
PARTITION p6 VALUES LESS THAN (2006) ENGINE = MYISAM,
PARTITION p7 VALUES LESS THAN (2007) ENGINE = MYISAM,
PARTITION p8 VALUES LESS THAN (2008) ENGINE = MYISAM,
PARTITION p9 VALUES LESS THAN (2009) ENGINE = MYISAM,
PARTITION p10 VALUES LESS THAN (2010) ENGINE = MYISAM,
PARTITION p12 VALUES LESS THAN MAXVALUE ENGINE = MYISAM)