mysql分区

来源:互联网 发布:淘宝扫码领红包怎么扫 编辑:程序博客网 时间:2024/06/16 12:05
CREATE TABLE IF NOT EXISTS `wj_forum` (  `fid` bigint(20) NOT NULL AUTO_INCREMENT,  `ftitle` varchar(255) NOT NULL,  `fcontent` text,  `ftime` int(11) DEFAULT NULL,  `fbigcate` varchar(50) DEFAULT NULL,  `fsmallcate` varchar(50) DEFAULT NULL,  PRIMARY KEY (`fid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 --此处不要有分号 partition BY RANGE (fid) (    partition p0 VALUES LESS THAN (200000),    partition p1 VALUES LESS THAN (400000),    partition p2 VALUES LESS THAN (600000),    partition p3 VALUES LESS THAN (800000));
0 0
原创粉丝点击