PARTITION BY 子句。按范围分区：，``sql，CREATE TABLE example (， id INT,， name VARCHAR(50),， created_at DATE，) PARTITION BY RANGE (YEAR(created_at)) (， PARTITION p0 VALUES LESS THAN (2020),， PARTITION p1 VALUES LESS THAN (2021),， PARTITION p2 VALUES LESS THAN (2022),， PARTITION p3 VALUES LESS THAN (MAXVALUE)，);，``Powered By Z-BlogPHP 1.7.3