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 );
CREATE TABLE Table1 ( id INT NOT NULL, type INT NOT NULL, info VARCHAR(100) ) PARTITION BY LIST(type) ( PARTITION p1 VALUES IN (1,2), PARTITION p2 VALUES IN (3,4), PARTITION p3 VALUES IN (5,6) );
CREATE TABLE table1( id int not null, eklenme_tarihi date not null) PARTITION by hash(YEAR(eklenme_tarihi)) PARTITIONS 10;eklenme_tarihi 2000 ise 1. partition, 2001 ise 2. partition, vb.. şeklinde kayıtlar bölümlenecektir
CREATE TABLE table1 ( id INT NOT NULL PRIMARY KEY, name VARCHAR(20) ) PARTITION BY KEY() PARTITIONS 2;yukarıda tablonun key alanına göre 2 partition oluşturulacaktır