Mysql 建表时分区及添加分区的sql语句

1、建表

-- 对表进行分区
CREATE TABLE users (
  id INT NOT NULL,
  NAME VARCHAR(255),
  age INT,
  create_time DATETIME
) PARTITION BY RANGE (YEAR(create_time)) (
  PARTITION p0 VALUES LESS THAN (2020),
  PARTITION p1 VALUES LESS THAN (2021),
  PARTITION p2 VALUES LESS THAN (2022),
  PARTITION p3 VALUES LESS THAN (2023)
);

2、添加新的分区

ALTER TABLE users ADD PARTITION (PARTITION p4 VALUES LESS THAN(2024));
ALTER TABLE users ADD PARTITION (PARTITION p5 VALUES LESS THAN(2025));
ALTER TABLE users ADD PARTITION (PARTITION p6 VALUES LESS THAN(2026));