Mysql yıllara ve aylara göre partition ekleme
ALTER TABLE tablo PARTITION BY RANGE( YEAR(tarih) ) SUBPARTITION BY HASH( MONTH(tarih) ) SUBPARTITIONS 12 ( PARTITION ocak VALUES LESS THAN (2), PARTITION subat VALUES LESS THAN (3), PARTITION mart VALUES LESS THAN (4), PARTITION nisan VALUES LESS THAN (5), PARTITION mayis VALUES LESS THAN (6), PARTITION haziran VALUES LESS THAN (7), PARTITION temmuz VALUES LESS THAN (8), PARTITION agustos VALUES LESS THAN (9), PARTITION eylul VALUES LESS THAN (10), PARTITION ekim VALUES LESS THAN (11), PARTITION kasim VALUES LESS THAN (12), PARTITION aralik VALUES LESS THAN (13) );