MYSQL

 新建数据库，新建表。

mysql> create database mydb15_indexstu;
mysql> use mydb15 indexstu;
mysql> create table student( sno int primary key auto_increment, sname varchar(30) not null unique, ssex varchar(2) check (ssex='男' or ssex='女') not null, sage int not null, sdept varchar(10) default '计算机'  not null);
mysql>  create table course(cno int primary key not null, cname varchar(20) not null);
mysql> create table sc(sno int not null,cno varchar(10) primary  key  not null , score int not null);
mysql> desc course;
mysql> desc sc;
mysql> desc student;

处理表： 

1 .修改Student表中年龄( sage )字段属性，数据类型由int改变为smallint

mysql> alter table  student modify sage  smallint;
mysql> desc student;

2 .为Course表中Cno课程号字段设置索引，并查看索引

mysql>  create unique index cno on Course(Cno);
mysql> show create table Course \G;

3 .为SC表建立按学号( sno )和课程号( cno )组合的升序的主键索引，索引名为SC _ INDEX

mysql>  create index SC_INDEX ON SC(Sno,Cno asc);

4 .创建一视图stu _ info，查询全体学生的姓名，性别，课程名，成绩

mysql> create view stu_info as select sname,ssex,cname,score from student,course,sc;
mysql> desc stu_info;

5 .删除所有索引

mysql> drop index cno on Course;
mysql> drop index SC_INDEX on SC;