Mycat2 哈希分片 WEEK

WEEK

僅用于分表

僅DATE/DATETIME

一周之中的星期(1-7)進(jìn)行取余運(yùn)算

tbpartitions不超過(guò)7

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