Yıla Göre Range Partition Yapan Basit Bir Örnek

CREATE TABLE Table1 (
    id INT NOT NULL,
	record_year DATE NOT NULL,
    info VARCHAR(100)
)
PARTITION BY RANGE ( record_year(separated) ) (
    PARTITION p0 VALUES LESS THAN (2013),
    PARTITION p1 VALUES LESS THAN (2012),
    PARTITION p2 VALUES LESS THAN (2011),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);