- 积分
- 49
- UID
- 13552
- 阅读权限
- 10
- 注册时间
- 2013-4-12
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
请问一下如何按月日建子分区。我写的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'))
)
)
);
|
|