mysql 分區查詢:mysql表分區查詢[朗讀]

下面是分區的例子!createtablesale(sale_idintnotnull,sale_datedatetime,moneyint)engine=myisam;altertablesalepartitionbyrangecolumns(sale_date)(partitionp01valueslessthan('2011-1-1'),partitionp02valueslessthan('2012-1-1'));