1. 以创建student表为例
CREATE TABLE student(
sno INT(8) NOT NULL,
sname VARCHAR(12) NOT NULL,
ssex ENUM('男','女'),
sage INT(8) NOT NULL,
sdept VARCHAR(12) NOT NULL DEFAULT '群众',
PRIMARY KEY (sno)
);
2.ALTER TABLE student CHANGE sage smallints INT(10);
3.CREATE INDEX sc_index ON sc (sno,cno ASC);
4.CREATE VIEW stu_info(sname,ssex,cname,score) AS SELECT student.sname,student.ssex,courese.cname,sc.score FROM student,courese,sc;