1Copied mysql> SHOW CREATE TABLE trb3\G
2*************************** 1. row ***************************
3 Table: trb3
4Create Table: CREATE TABLE `trb3` (
5 `id` int(11) default NULL,
6 `name` varchar(50) default NULL,
7 `purchased` date default NULL
8) ENGINE=MyISAM DEFAULT CHARSET=latin1
9PARTITION BY RANGE (YEAR(purchased)) (
10 PARTITION p0 VALUES LESS THAN (1990) ENGINE = MyISAM,
11 PARTITION p1 VALUES LESS THAN (1995) ENGINE = MyISAM,
12 PARTITION p2 VALUES LESS THAN (2000) ENGINE = MyISAM,
13 PARTITION p3 VALUES LESS THAN (2005) ENGINE = MyISAM
14)
151 row in set (0.00 sec)