56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> create table t1 (
-> id int,
-> year_col int
-> )
-> partition by range (year_col) (
-> partition p0 values less than (1991),
-> partition p1 values less than (1995),
-> partition p2 values less than (1999)
-> );
Query OK, 0 rows affected (0.03 sec)
mysql>
mysql> alter table t1 add partition (PARTITION p3 values less than (2002));
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql>