mysql经典面试习题21道（包含答案）
需积分: 1 180 浏览量
2023-12-08
00:09:30
上传
评论
收藏 142KB PDF 举报
初始化数据
create table class
(
classid int,
classname varchar(20)
);
insert into class values(1,'G1T01');
insert into class values(2,'G1T02');
insert into class values(3,'G1T03');
insert into class values(4,'G1T04');
insert into class values(5,'G1T05');
insert into class values(6,'G1T06');
insert into class values(7,'G1T07');
create table student
(
studentid varchar(20) ,
studentname varchar(20),
studentage int,
studentsex char(10),
studentaddress varchar(50),
classid int
);
insert into student values('2010001','Jack',21,'男','湖北襄樊',1);
insert into student values('2010002','Scott',22,'男','湖北武汉',2);
insert into student values('2010003','Lucy',23,'女','湖北武汉',3);
insert into student values('2010004','Alan',19,'女','湖北襄樊',4);
insert into student values('2010005','Bill',20,'男','湖北襄樊',5);
insert into student values('2010006','Bob',21,'男','湖北宜昌',6);
insert into student values('2010007','Colin',22,'女','湖北襄樊',6);
insert into student values('2010008','Fred',19,'男','湖北宜昌',5);
insert into student values('2010009','Hunk',19,'男','湖北武汉',4);
insert into student values('2010010','Jim',18,'男','湖北襄樊',3);
create table computer
(
studentid varchar(20),
score double
);
insert into computer values('2010001',90);
insert into computer values('2010002',80);
insert into computer values('2010003',70);
insert into computer values('2010004',60);
insert into computer values('2010005',75);
资源评论
