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

报什么错误？要建立MySQL分区，是要选择支持MySQL分区的版本才行...

专注

mysql 5.5.25 ，报语法错误。

zhangxing2288

过来星辰变学习学习啊~~