CREATE TABLE users
(
    id INT(11) NOT NULL ,
    username VARCHAR(50) NOT NULL ,
    register_date DATETIME NOT NULL
)
PARTITION BY RANGE( YEAR(register_date) )
(
    PARTITION p0 VALUE LESS THAN (2006) ,
    PARTITION p1 VALUE LESS THAN (2007) ,
    PARTITION p2 VALUE LESS THAN (2008) ,
    PARTITION p3 VALUE LES THAN MAXVALUE
);