论坛 › MySQL优化与深入 › MySQL按月、日如何建子分区

专注 发表于 2013-4-12 09:42:10

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:08

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

专注 发表于 2013-4-15 16:45:25

mysql 5.5.25 ，报语法错误。

zhangxing2288 发表于 2013-6-28 23:40:42

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

查看完整版本: MySQL按月、日如何建子分区