mysql建分区表语句_简单创建mysql分区表语句CREATE TABLE `test_log_1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mobile` char(11) NOT NULL,
`reg_date` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`,`reg_date`),
KEY `reg_date` (`reg_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PARTITION BY RANGE (reg_date)
(PARTITION p0 VALUES LESS THAN (20120201) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (20120301) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (20120401) ENGINE = MyISAM,
PARTITION p3 VALUES LESS THAN (20120501) ENGINE = MyISAM,
无向图的邻接矩阵怎么画PARTITION p4 VALUES LESS THAN (20120601) ENGINE = MyISAM,
PARTITION p5 VALUES LESS THAN (20120701) ENGINE = MyISAM,
PARTITION p6 VALUES LESS THAN (20120801) ENGINE = MyISAM,
PARTITION p7 VALUES LESS THAN (20120901) ENGINE = MyISAM,
imgpayPARTITION p8 VALUES LESS THAN (20121001) ENGINE = MyISAM,
PARTITION p9 VALUES LESS THAN (20121101) ENGINE = MyISAM,
PARTITION p10 VALUES LESS THAN (20121201) ENGINE = MyISAM,特效相册
PARTITION p11 VALUES LESS THAN (20130101) ENGINE = MyISAM,
PARTITION p12 VALUES LESS THAN (20130201) ENGINE = MyISAM,
PARTITION p13 VALUES LESS THAN MAXVALUE ENGINE = MyISAM);
苹果launchpad是什么
分享到：
sol日历下载 官方
2012-05-07 14:31
浏览 4943
mysql语句分类分类：数据库
评论

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。