CREATETABLEpart_tab(c1intdefaultNULL,c2varchar(30)defaultNULL,c3datedefaultNULL)engine=myisamPARTITIONBYRANGE(year(c3))(PARTITIONp0VALUESLESSTHAN(1995),PARTITIONp1VALUESLESSTHAN(1996),PARTITIONp2VALUESLESSTHAN(1997),PARTITIONp3VALUESLESSTHAN(1998),PA...
(more)