HASH型分片算法-MM

MM

仅用于分表

仅支持DATE/DATETIME
月份(1-12)%分表数
tbpartitions不超过12

create table travelrecord (
 ....
) ENGINE=InnoDB DEFAULT CHARSET=utf8 
dbpartition by xxx(xxx) dbpartitions 12
tbpartition by MM(xxx) tbpartitions 12;