asp.net网站开发,常用的网站都有哪些,中建八局一公司官网,天津微信网站建设在对表进行分区时#xff0c;如果分区字段没有包含在主键字段内#xff0c;如表A的主键为ID,分区字段为createtime #xff0c;按时间范围分区#xff0c;代码如下#xff1a; www.2cto.comCREATE TABLE T1 (id int(8) NOT NULL AUTO_INCREMENT,createtime datetime NOT …在对表进行分区时如果分区字段没有包含在主键字段内如表A的主键为ID,分区字段为createtime 按时间范围分区代码如下 www.2cto.comCREATE TABLE T1 (id int(8) NOT NULL AUTO_INCREMENT,createtime datetime NOT NULL,PRIMARY KEY (id)) ENGINEInnoDB AUTO_INCREMENT1 DEFAULT CHARSETutf8PARTITION BY RANGE(TO_DAYS (createtime))(PARTITION p0 VALUES LESS THAN (TO_DAYS(2010-04-15)),PARTITION p1 VALUES LESS THAN (TO_DAYS(2010-05-01)),PARTITION p2 VALUES LESS THAN (TO_DAYS(2010-05-15)),PARTITION p3 VALUES LESS THAN (TO_DAYS(2010-05-31)),PARTITION p4 VALUES LESS THAN (TO_DAYS(2010-06-15)),PARTITION p19 VALUES LESS ThAN MAXVALUE);错误提示#1503原载于联动北方
