数据库实验报告(实验二)概论
沈阳工程学院
学生实验报告
(课程名称:数据库系统原理)
实验题目:数据更新
班级计算机学号 2 姓名
日期20年月日地点F608 指导教
师
图1
(2)在goods表中输入6条记录,如图2所示。
insert
into goods
values('01','耳机','100');
insert
into goods
values('02','u盘','200');
insert
into goods
values('03','键盘','300');
insert
into goods
values('04','鼠标','400');
insert
into goods
values('05','手机','500');
insert
into goods
values('06','电脑','600');
图2
(3)在purchase表中输入10条记录,如图3所示。
insert
into purchase
values('01','1',to_date('21-08-2013','dd-mm-yyyy'),'1');
insert
into purchase
values('01','2',to_date('01-08-2013','dd-mm-yyyy'),'3');
insert
into purchase
values('02','1',to_date('25-08-2013','dd-mm-yyyy'),'5');
insert
into purchase
values('02','3',to_date('21-09-2013','dd-mm-yyyy'),'4');
insert
into purchase
values('02','6',to_date('21-08-2011','dd-mm-yyyy'),'3');
insert
into purchase
values('03','4',to_date('21-02-2013','dd-mm-yyyy'),'2');
insert
into purchase
values('03','5',to_date('11-08-2013','dd-mm-yyyy'),'3');
insert
into purchase
values('04','1',to_date('21-08-2013','dd-mm-yyyy'),'5');
insert
into purchase
values('05','4',to_date('25-08-2013','dd-mm-yyyy'),'4');
insert
into purchase
values('06','5',to_date('21-01-2013','dd-mm-yyyy'),'2');
图3
(4)将id为1的顾客的年龄改为20岁,如图4-1所示。
update guest
set g_age=20
where guestid=1;
图4-1
在guest表中插入一条新记录,如图4-2所示;然后将其删除,如图4-3所示。
insert
into guest(guestid,guestname,g_age,g_addr,g_work)
values('7','王江','22 ','北京','学生');
delete
from guest
where guestid='7';
图4-2
图4-3
(5)在purchase表中增加多条记录,如图5-1所示,将销售数为1的记录的日期都改为25-02-2000,如图5-2和5-3所示,删除日期为25-02-2000的销售记录,如图5-4和5-5所示。
insert
into purchase
values('05','1',to_date('25-02-2015','dd-mm-yyyy'),'1'); insert
into purchase
values('06','3',to_date('25-02-2015','dd-mm-yyyy'),'1'); insert
into purchase
values('04','4',to_date('25-02-2015','dd-mm-yyyy'),'1');
update purchase
set purchase_date= to_date('25-02-2000','dd-mm-yyyy') where purchase_num=1;
delete
from purchase
where purchase_date= to_date('25-02-2000','dd-mm-yyyy');
图5-1
图5-2
图5-3
图5-4
图5-5