有时候数据量庞大需要用到分表
1.首先创建一个表名,这个表名要有规则方便以后查询使用
String xsellTableName = "zp_suitcar_xsell_"+userDo.getId();
2.创建表
@Update("create table ${tableName} ("
+ " id bigint(20) primary key not null auto_increment,"
+ " product_id bigint(20) not null,"
+ " prop varchar(255),"
+ " pgroup bigint(8),"
+ " cls_id int(11),"
+ " spart_id int(11),"
+ " spart_name varchar(100),"
+ " position_id int(11),"
+ " position_name varchar(100),"
+ " brand_id int(11),"
+ " brand_name varchar(100),"
+ " factory_id int(11),"
+ " factory_name varchar(100),"