题解 | #创建索引#

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

索引的创建

1、普通索引

create index index_name on table_name (column1[asc|desc , column2[asc|desc] , ......)

或者

alter table table_name

add index index_name (column1[asc|desc , column2[asc|desc] , ......)

2、创建唯一索引

create unique index index_name on table_name (column1[asc|desc , column2[asc|desc] , ......)

或者

alter table table_name

add unique index index_name (column1[asc|desc , column2[asc|desc] , ......)

3、创建全文索引

create fulltext index index_name on table_name (column1[asc|desc , column2[asc|desc] , ......)