mysql分区

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)
);