MariaDB社区

标题: MySQL按月、日如何建子分区 [打印本页]

作者: 专注 时间: 2013-4-12 09:42
标题: MySQL按月、日如何建子分区
请问一下如何按月日建子分区。我写的sql报异常。

CREATE TABLE test.ts111 (id INT, cdate DATETIME)
PARTITION BY RANGE(year(cdate))
SUBPARTITION BY RANGE(TO_DAYS(cdate))
(
  PARTITION p_e VALUES LESS THAN (to_days('2013-04-01'))
  (
SUBPARTITION BY RANGE(TO_DAYS(cdate))
(
   PARTITION s_310 VALUES LESS THAN (to_days('2013-03-10')),
   PARTITION s_311 VALUES LESS THAN (to_days('2013-03-11')),
   PARTITION s_312 VALUES LESS THAN (to_days('2013-03-12'))
)
  ),
  PARTITION p_4 VALUES LESS THAN (to_days('2013-05-01'))
  (
SUBPARTITION BY RANGE(TO_DAYS(cdate))
(
   PARTITION s_340 VALUES LESS THAN (to_days('2013-04-10')),
   PARTITION s_341 VALUES LESS THAN (to_days('2013-04-11')),
   PARTITION s_342 VALUES LESS THAN (to_days('2013-04-12'))
)
  ),
  PARTITION p_5 VALUES LESS THAN (to_days('2013-06-01'))
  (
SUBPARTITION BY RANGE(TO_DAYS(cdate))
(
   PARTITION s_350 VALUES LESS THAN (to_days('2013-05-10')),
   PARTITION s_351 VALUES LESS THAN (to_days('2013-05-11')),
   PARTITION s_352 VALUES LESS THAN (to_days('2013-05-12'))
)
  )
);

作者: kider 时间: 2013-4-12 10:24
报什么错误？要建立MySQL分区，是要选择支持MySQL分区的版本才行...

作者: 专注 时间: 2013-4-15 16:45
mysql 5.5.25 ，报语法错误。

欢迎光临 MariaDB社区 (http://123.56.88.72/)