分区表(二),分区表
alter table scales add partition (partition p2 values less than (2015));
alter table log drop partition p0;
show variables like '%partition%';
alter table user reorganize partition p0,p1,p2 into (partition p3 values less than (2011));
alter table log partition by hash(YEAR(time)) partitions 6;
alter table x partition by range(salary)(partition values less than 100);
alter table x rebuild partition p0,p1;
alter table x optimize partition p1,p2;
alter table x analyze partition p1,p2;
alter table x repair partition p1,p2;
explain partitions select * from log where YEAR(time)>2016-06-01 and YEAR(time)<2016-06-30;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。