ALTER TABLE t_paper_question MODIFY paper_id varchar(32) NOT NULL COMMENT '试卷';
-- 先删除原主键
ALTER TABLE t_paper_question DROP PRIMARY KEY;
-- 添加新复合主键
ALTER TABLE t_paper_question ADD PRIMARY KEY (id, paper_id);
ALTER TABLE t_paper_question ADD KEY idx_paper_id (paper_id);
ALTER TABLE t_paper_question
PARTITION BY KEY(paper_id)
PARTITIONS 16;
先按照t_paper_question 中的进行筛选
浙公网安备 33010602011771号