mysql数据表准备

#建表语句
create table students(sid char(10),name varchar(30),gender varchar(10) default "male",age int,score int);
#插入数据
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1001', 'lili', 'male',  14,88);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1002', 'wang', 'female',16,92);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1003', 'tywd', 'male',  15,88);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1004', 'hfgs', 'female',14,96);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1005', 'qwer', 'male',  13,77);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1006', 'zxsd', 'female',17,89);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1007', 'hjop', 'male',  15,96);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1008', 'tyop', 'female',16,89);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1009', 'nhmk', 'male',  14,77);
INSERT INTO students (sid,name,gender,age,score) VALUES ('S_1010', 'xdfv', 'female',16,50);
#建索引
alter table students add index name_index(name);#普通索引：单列，允许空，允许重复
alter table students add primary key (sid);#主键索引：单列，不允许空，不允许重复
#alter table students add unique(sid);#唯一索引：单列，不允许重复，（多个null也算重复吧）
alter table students add index age_score_indexes (age,score);#复合索引

#查看有哪些索引
show indexes from students;
#删除索引
alter table students drop index age_score;