mysql统计没有参加考试的学生名单_sQL SERVER,帮我编写一个存储过程，查询没有参加考试的学生名单，要求显示姓名、学号，具体请补充：...-CSDN博客

本文链接：https://blog.csdn.net/weixin_30672649/article/details/113585864

这篇博客介绍如何在MySQL中通过SQL查询找出没有参加任何考试的学生名单。通过创建和操作三个表格（学生表、课程表和成绩表），并插入相关数据，最后展示了一个存储过程来查询特定课程的考试参与者，但需要进一步修改以获取未参加任何考试的学生。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--学生表CREATETABLEmember(midchar(10)primarykey,mnamechar(50)notnull,);--课程表CREATETABLEcourse(fidchar(10)primarykey,fnamechar(50)notnull,);--成绩表select*fromscoreCREA...

--学生表

CREATE TABLE member(

mid char(10) primary key,

mname char(50) not null,

);

--课程表

CREATE TABLE course(

fid char(10) primary key,

fname char(50) not null,

);

--成绩表

select * from score

CREATE TABLE score(

scid int identity(1,1) primary key,

fid char(10) foreign key(fid) references course(fid),

mid char(10) foreign key(mid) references member(mid),

sconum int,

);

--课程表中插入数据--

insert into course

values('F001','语文')

insert into course

values('F002','数学')

insert into course

values('F003','英语')

insert into course

values('F004','历史')

--学生表中插入数据--

select * from member

insert into member

values('M001','张萨')

insert into member

values('M002','王强')

insert into member

values('M003','李三')

insert into member

values('M004','李四')

insert into member

values('M005','阳阳')

insert into member

values('M006','虎子')

insert into member

values('M007','夏雪')

insert into member

values('M008','璐璐')

insert into member

values('M009','珊珊')

insert into member

values('M010','香奈儿')

--成绩表中插入数据--

SELECT * FROM score

order by scid,fid

INSERT INTO score

values('F004','M009',79)

INSERT INTO score

values('F001','M001',78)

INSERT INTO score

values('F002','M001',67)

INSERT INTO score

values('F003','M001',89)

INSERT INTO score

values('F004','M001',76)

INSERT INTO score

values('F001','M002',89)

INSERT INTO score

values('F001','M002',67)

INSERT INTO score

values('F003','M002',84)

INSERT INTO score

values('F004','M002',96)

INSERT INTO score

values('F001','M003',70)

INSERT INTO score

values('F002','M003',87)

INSERT INTO score

values('F003','M003',92)

INSERT INTO score

values('F004','M003',56)

INSERT INTO score

values('F001','M004',80)

INSERT INTO score

values('F002','M004',78)

INSERT INTO score

values('F003','M004',97)

INSERT INTO score

values('F004','M004',66)

INSERT INTO score

values('F001','M006',88)

INSERT INTO score

values('F002','M006',55)

INSERT INTO score

values('F003','M006',86)

INSERT INTO score

values('F002','M007',77)

INSERT INTO score

values('F003','M008',65)

INSERT INTO score

values('F004','M007',48)

INSERT INTO score

values('F004','M009',75)

INSERT INTO score

values('F002','M009',88)

如果查询参加具体学科考试的人我知道怎样写(如下)，怎样写没有参加考试的学生名单啦？

create proc p_stu3

@cname char(20)

select 学生姓名,课程名,学生号

from vw2 /*创建的三表连接的视图

where 课程名=@cname

展开