create database example
use example
create table major
(
spno varchar(10) primary key not null,
spname varchar(20) not null
)
create table student
(
sno varchar(10) primary key not null,
sname varchar(10) not null,
ssex varchar(2) not null,
spno varchar(10) foreign key references major(spno)
)
create table course
( cno varchar(10) primary key not null,
cname varchar(10) not null
)
create table scourse
(
sno varchar(10) foreign key references student(sno),
cno varchar(10) foreign key references course(cno),
gmark int
)
insert into major values('001','英语')
insert into major values('002','语文')
insert into major values('003','数学')
insert into major values('004','生物')
insert into major values('005','物理')
insert into major values('006','化学')
insert into student values('2007151301','bobo','男','001')
insert into student values('2007151302','roy','男','002')
insert into student values('2007151303','max','男','004')
insert into student values('2007151304','tony','男','004')
insert into student values('2007151305','jaims','男','005')
insert into student values('2007151306','wing','男','006')
insert into student values('2007151307','allen','男','001')
insert into student values('2007151308','heng','男','002')
insert into student values('2007151309','chart','男','003')
insert into course values('001','乒乓球')
insert into course values('002','篮球')
insert into course values('003','足球')
insert into course values('004','网球球')
insert into course values('005','舞蹈')
insert into course values('006','瑜伽')
insert into course values('007','游泳')
insert into scourse values('2007151301','001','88')
insert into scourse values('2007151302','002','88')
insert into scourse values('2007151303','003','88')
insert into scourse values('2007151304','004','88')
insert into scourse values('2007151305','005','88')
insert into scourse val
所谓视图（View）其实是执行查询语句后得到的结果，但这个查询结果可以仿真成数据表来使用，所以有人也称它为“虚拟数据表”，视图在操作上和数据表没有什么区别，但两者的差异是其本质是不同的：数据表是实际存储记录的地方，然而视图并不保存任何记录，它存储的实际上是查询语句，其所呈现� ......
