Re: Partitioning by year/quarter

[Aftab Khan]

One way to accomplish this is to create a table partitioned by LIST, using the YEAR and QUARTER() function in the partitioning expression

mysql> select YEAR(now()) * 100 + QUARTER(now());
+------------------------------------+
| YEAR(now()) * 100 + QUARTER(now()) |
+------------------------------------+
|                             201203 |
+------------------------------------+
1 row in set (0.00 sec)

e.g.

PARTITION BY LIST(YEAR(FIRSTOCCURRENCE) * 100 + QUARTER(FIRSTOCCURRENCE)) (
    PARTITION y2012q3 VALUES IN(201203),
    PARTITION y2012q4 VALUES IN(201204),
....
);