[哈希分片]YYYYMM

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

YYYYMM

仅用于分库

(YYYY*12+MM)%分库数

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