MySQL分区

最新推荐文章于 2025-12-05 12:37:18 发布

转载最新推荐文章于 2025-12-05 12:37:18 发布 · 100 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2361141/blog/778772

文章标签：

#数据库

我这里是按年份分区

ALTER TABLE snatchurl PARTITION BY RANGE(`range`)(
PARTITION p08 VALUES LESS THAN (2008),
PARTITION p09 VALUES LESS THAN (2009),
PARTITION p10 VALUES LESS THAN (2010),
PARTITION p11 VALUES LESS THAN (2011),
PARTITION p12 VALUES LESS THAN (2012),
PARTITION p13 VALUES LESS THAN (2013),
PARTITION p14 VALUES LESS THAN (2014),
PARTITION p15 VALUES LESS THAN (2015),
PARTITION p16 VALUES LESS THAN (2016),
PARTITION pmax VALUES LESS THAN MAXVALUE
);

注意：`range`字段需设为主键

转载于:https://my.oschina.net/u/2361141/blog/778772