[数据分片]HASH型分片算法-DD

DD

仅用于分表

仅DATE/DATETIME
一月中的第几天(1-31)%分表数
tbpartitions不能超过31

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