题解 | #创建索引#

create index idx_duration on examination_info(duration);
create unique index uniq_idx_exam_id on examination_info(exam_id);
create fulltext index full_idx_tag on examination_info(tag);

-- 普通索引

CREATE INDEX idx_duration ON examination_info(duration);

-- 唯一索引

CREATE UNIQUE INDEX uniq_idx_exam_id ON examination_info(exam_id);

-- 全文索引

CREATE FULLTEXT INDEX full_idx_tag ON examination_info(tag);