题解 | #删除索引#

两种做法：

1、drop

语法：DROP INDEX index_name ON tbl_name

drop index uniq_idx_exam_id on examination_info;
drop index full_idx_tag on examination_info;

2、alter

语法：alter tb_name drop index index_name

alter table examination_info
    drop INDEX uniq_idx_exam_id;
alter table examination_info
    drop INDEX  full_idx_tag;