题解 | #创建索引#

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);

一个知识点:

索引的分类:主键索引(primary index),唯一索引(unique index),常规索引(index),全文索引(fulltext index).

创建索引:

create [unique|fulltext] index idx_name on table_name(字段)

删除索引:

drop index idx_name on tb_name.

查看索引:

show index from tb_name.