DROP TABLE IF EXISTS `stb`; CREATE TABLE `stb` ( `id` int(15) NOT NULL AUTO_INCREMENT, `mobile` varchar(20) DEFAULT NULL, `service` varchar(20) DEFAULT NULL, `msg` varchar(100) DEFAULT NULL, `longnum` varchar(20) DEFAULT NULL, `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`,`time`) ) ENGINE=MyISAM AUTO_INCREMENT=378 DEFAULT CHARSET=utf8; /*!50100 PARTITION BY RANGE (to_days(`time`)) (PARTITION p201203 VALUES LESS THAN (734959) ENGINE = MyISAM, PARTITION p201204 VALUES LESS THAN (734989) ENGINE = MyISAM, PARTITION p201205 VALUES LESS THAN (735020) ENGINE = MyISAM) */;这是建表语句 到这一步 /*!50100 PARTITION BY RANGE (to_days(`time`)) 就报错 Script line: 80 Partitioning can not be used stand-alone in query near 'PARTITION BY RANGE (to_days(`time`)) (PARTITION p201203 VALUES LESS THAN (73495' at line 1
PARTITION BY RANGE(TO_DAYS (createtime)) ( PARTITION p20101115 VALUES LESS THAN (TO_DAYS('2010-11-15')), PARTITION p20101130 VALUES LESS THAN (TO_DAYS('2010-11-30')), PARTITION p20101215 VALUES LESS THAN (TO_DAYS('2010-12-15')), PARTITION p20101231 VALUES LESS THAN (TO_DAYS('2010-12-31')), PARTITION p20110115 VALUES LESS THAN (TO_DAYS('2011-01-15')), PARTITION p20110131 VALUES LESS THAN (TO_DAYS('2011-01-31')),这么写的。
CREATE TABLE `stb` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`mobile` varchar(20) DEFAULT NULL,
`service` varchar(20) DEFAULT NULL,
`msg` varchar(100) DEFAULT NULL,
`longnum` varchar(20) DEFAULT NULL,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`,`time`)
) ENGINE=MyISAM AUTO_INCREMENT=378 DEFAULT CHARSET=utf8;
/*!50100 PARTITION BY RANGE (to_days(`time`))
(PARTITION p201203 VALUES LESS THAN (734959) ENGINE = MyISAM,
PARTITION p201204 VALUES LESS THAN (734989) ENGINE = MyISAM,
PARTITION p201205 VALUES LESS THAN (735020) ENGINE = MyISAM) */;这是建表语句 到这一步 /*!50100 PARTITION BY RANGE (to_days(`time`))
就报错 Script line: 80 Partitioning can not be used stand-alone in query near 'PARTITION BY RANGE (to_days(`time`))
(PARTITION p201203 VALUES LESS THAN (73495' at line 1
PARTITION BY RANGE(TO_DAYS (createtime))
(
PARTITION p20101115 VALUES LESS THAN (TO_DAYS('2010-11-15')),
PARTITION p20101130 VALUES LESS THAN (TO_DAYS('2010-11-30')),
PARTITION p20101215 VALUES LESS THAN (TO_DAYS('2010-12-15')),
PARTITION p20101231 VALUES LESS THAN (TO_DAYS('2010-12-31')),
PARTITION p20110115 VALUES LESS THAN (TO_DAYS('2011-01-15')),
PARTITION p20110131 VALUES LESS THAN (TO_DAYS('2011-01-31')),这么写的。