索引(index)

#创建索引
create index index_name_pass on student(name,pass);
create index index_name_id on student(name,id);
#删除索引
alter table student drop index index_name_pass
#修改列名
alter table student change pass passes char