##查看索引
SHOW INDEX FROM student;
##创建普通索引
CREATE INDEX idx_studentname ON student(StudentName);
##创建唯一索引
CREATE UNIQUE INDEX idx_phone ON student(phone);
##删除索引
DROP INDEX idx_studentname ON student;
##查看索引
SHOW INDEX FROM student;
##创建普通索引
CREATE INDEX idx_studentname ON student(StudentName);
##创建唯一索引
CREATE UNIQUE INDEX idx_phone ON student(phone);
##删除索引
DROP INDEX idx_studentname ON student;