create table sailors(
sid char(10) primary key,
sname char(20),
rating int,
age int);
create table boats(
bid char(10) primary key,
bname char(20),
color char(10));
create table reserves(
sid char(10) ,
bid char(10) ,
rdate date,
primary key(sid,bid,rdate),
foreign key (sid) references sailors(sid) on delete cascade,
foreign key (bid) references boats(bid) on delete cascade);
insert into sailors(sid,sname,rating,age)
values("22","dustin",7,45)
("29","brustus",1,33),
("31","lubber",8,56),
("32","andy",8,26),
("58","rusty",10,35),
("64","horatio",7,35),
("71","zorba",10,35),
("74","horatio",9,35),
("85","art",3,26),
("86","john",1,17),
("95","bob",3,64),
("96","frodo",3,26),
("98","tom",3,17);
insert into boats(bid,bname,color)
values("101","A","red"),
("102","B","green"),
("103","C","blue"),
("104","D","white")
("105","E","red"),
("106","F","blue"),
("107","G","green");
insert into reserves(sid,bid,rdata)
values("22","101","2010-01-08"),
("22","102","2010-01-09"),
("29","103","2010-01-09"),
("31","102","2010-02-11"),
("22","104","2010-03-08"),
("22","103","2010-03-10"),
("32","105","2010-03-11"),
("32","106","2010-03-18"),
("32","102","2010-03-19"),
("58","104","2010-03-20"),
("64","105","2010-03-20"),
("95","101","2010-04-02"),
("85","102","2010-04-05"),
("22","101","2010-04-07"),
("22","105","2010-05-01"),
("22","106","2010-06-18"),
("22","107","2010-07-09"),
("31","106","2010-08-06"),
("32","105","2010-08-06"),
("29","104","2010-08-07"),
("64","103","2010-09-05"),
("58","102","2010-09-09"),
("64","104","2010-11-03"),
("64","105","2010-11-04"),
("31","106","2010-12-0
232
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
