《数据库原理与设计实验》报告
(实验 4:DML 数据操纵实验 )
题 目 博客系统
组 号
学 号
姓 名
2022 年 5 月 12 日
- 1 -
一、插入数据 INSERT 操作 (20 分)
要求:向本组设计的数据库中的表插入数据(至少 4 张,需要能满足下面所有
的查询、视图、触发器验证要求,每张表的数据要求在 20 条以上,数据要符合实
际语义,本组内的表数据要求各自独立完成,若数据相同则相同者均计 0 分。
1、关系名 Blogger_2020112289
(
1
)关系对应的
DDL
:
create table Blogger_2020112289(
BID char(5) primary key,
BName varchar(10) not null,
BTel char(11) not null,
BEmail varchar(16) not null,
BGender char(1) check(BGender in ('F','M')),
BAge TINYINT not null,
BFansnum int not null
);
(
2
)对应的
INSERT
语句
insert into blogger_2020112289 values('20001','张
三','18711444393',
'264179738@qq.com','M',18,2190);
insert into blogger_2020112289 values('20002','李
四','19712354758',
'124579738@qq.com','M',16,123);
insert into blogger_2020112289 values('20003','程
强','13711748956',
'261244738@qq.com','M',12,453);
insert into blogger_2020112289 values('20004','李
明','15632235689',
'145621237@qq.com','M',21,12345);
insert into blogger_2020112289 values('20005','王
红','15623478956',
- 2 -
'147523889@qq.com','F',18,45631);
insert into blogger_2020112289 values('20006','刘
明','17456892356',
'154878235@qq.com','M',23,46);
insert into blogger_2020112289 values('20007','何
雨','13457821654',
'123567895@qq.com','F',18,757);
insert into blogger_2020112289 values('20008','伍自
成','17454589053',
'123454781@qq.com','M',18,6456);
insert into blogger_2020112289 values('20009','崔
迪','14325687894',
'256312478@qq.com','M',18,13554);
insert into blogger_2020112289 values('20010','胡
倩','17452358987',
'125452357@qq.com','F',22,678);
insert into blogger_2020112289 values('20011','李
峰','14756238987',
'124536987@qq.com','M',18,4564);
insert into blogger_2020112289 values('20012','成
龙','13232775648',
'145623781@qq.com','M',15,457);
insert into blogger_2020112289 values('20013','李
丽','14959231423',
'135455214@qq.com','F',13,464);
insert into blogger_2020112289 values('20014','王于
海','17456237089',
'123654578@qq.com','M',18,678);
insert into blogger_2020112289 values('20015','王海
城','15623452307',
- 3 -
'541236745@qq.com','M',18,45);
(
3
)执行结果(截图)
SELECT * FROM blogger_2020112289
2、关系名 Admin_2020112289
(
1
)关系对应的
DDL
:
create table Admin_2020112289(
AID char(5) primary key,
AName varchar(10) not null,
ATel char(11) not null,
AEmail varchar(16) not null,
AGender char(1) check(AGender in ('F','M')),
AAge TINYINT not null
);
(2)
对应的
INSERT
语句
insert into admin_2020112289 values('30001','王荷','14525788965',
'364049738@qq.com','F',18);
insert into admin_2020112289 values('30002','王雨','19563354758',
- 4 -