HASH型分片算法-MMDD

MMDD

仅用于分表

仅DATE/DATETIME
一年之中第几天%分表数
tbpartitions不超过366

create table travelrecord (
 ....
) ENGINE=InnoDB DEFAULT CHARSET=utf8 
dbpartition by xxx(xx) dbpartitions 8
tbpartition by MMDD(xx) tbpartitions 366;