只是做分区的语法了解,学习数据分区,所以仅仅新建三个月的数据,以便了解
alter table 表名 partition by range(to_days(字段)) () ----- 以下的测试是按时间来分区的(student没设置主键)
如:
alter table student partition by range(to_days(`day`)) (
partition p200108 values less than (to_days('2001-08-01')),
partition p200109 values less than (to_days('2001-09-01')),
partition p200110 values less than (to_days('2001-10-01')),
PARTITION p_max VALUES LESS ThAN MAXVALUE
)