Mysql 索引详情

create index putong_index on student(sname)

-- 普通索引

create unique index uni_index on student(money)

-- 唯一索引

alter table student add PRIMARY key(sid)

-- 修改索引

show index from student

-- 查看索引

drop index uni_index on student

-- 删除索引

create view v_student as

select sid,sname,sage from student

-- 视图