1.在CourseInfo表的CourseName列上创建一个普通索引I_CourseInfoCourseName
create index I_CourseInfoCourseName on CourseInfo(CourseName);
2.在StudentInfo1表的StudentID列上创建一个索引I_StudentInfo1StudentID,要按照学号StudentID字段值的前4个字符降序排列。
create index I_CourseInfoCourseName on StudentInfo(StudentID(4)desc);
3.在CourseInfo表的Credit列(降序)和CourseID列(升序)创建一个组合索引I_CourseInfoCreditCourseID
alter table CourseInfo
add index I_CourseInfoCreditCourseID(Credit,CourseID);
4、创建新表TeacherInfo1表,主键为TeacherID,同时在TeacherName列上创建唯一性索引
create table TeacherInfol
TeacherID varchar(4) not null primary key, TeacherName varchar(8) not null unique,
TeacherSex varchar(2) not null default'男', TeacherBirthday date not null, School varchar(12) null, Address varchar(20)null
5.查看(4)所创建的TeacherInfo1表的索引
show index from TeacherInfo1;
6.删除已建索引I_StudentInfo1StudentID
drop index I_StudentInfo1StudentID;
7.删除已建索引I_CourseInfoCreditCourseID
alter table courseinfo
drop index I_CourseInfoCreditCourseID;