- 博客(6)
- 问答 (1)
- 收藏
- 关注
原创 触发器个人复习用
if(NEW.Tprof not in('助教', '讲师', '副教授', '教授')) then。IF (NEW.Tprof NOT IN ('助教','讲师','副教授','教授')) THEN。if(NEW.Tprof not in('助教', '讲师', '副教授', '教授')) then。IF (NEW.Tprof NOT IN ('助教','讲师','副教授','教授')) THEN。ELSEIF (OLD.Tprof='讲师' AND NEW.Tprof='副教授') THEN。
2024-01-05 03:14:43
796
1
原创 数据库基本表个人复习
Sgender ENUM('男','女') DEFAULT '男' COMMENT '性别',add Tprof VARCHAR(8) COMMENT '职称' after Tgender,Dname VARCHAR(15) NOT NULL COMMENT '学院名称',Dname VARCHAR(15) NOT NULL COMMENT '学院名称');答案提交:(1)按要求写出创建数据库的SQL语句;Mname VARCHAR(15) NOT NULL COMMENT '专业名称',
2024-01-05 03:12:53
459
1
原创 数据库单表
SELECT Sno AS "学号",Cno AS "课程号",CASE WHEN Grade>='90' THEN '优'SELECT Sno AS "学号",Sname AS "学生姓名",Sbirth AS "出生日期",SELECT Sno AS "学号", Sname AS "姓名", Sbirth AS "出生日期",='广东潮州' and Snative not like '山东%';AS "平均分",MAX(Grade) AS "最高分",MIN(Grade) AS "最低分"
2024-01-05 03:11:40
533
1
原创 复杂查询复习
SELECT LEFT(S.Sno,4) '年级', S.Sno '学号', Sname '姓名', Grade '成绩'select t.tno'编号',t.Tname'姓名',t.Tprof'职称',t.Tsal+t.Tcomm'总工资'(COALESCE(CAST(FORMAT(AvgGrd,2) AS CHAR),'尚无成绩')) '平均分',select t2.tno'教师编号',t2.tname'姓名',t2.Tsal+t2.Tcomm'总工资'where cname='数据结构'));
2024-01-05 03:10:44
649
1
原创 更新操作,复习专用
('2022', '李xx','男', '1965-3-20','广东广州', '11', '1121',where Tname in ('李力','张兰','张雪')) DT where D.Dno = DT.Dno;('2022030381', '张xx','男', '1965-3-20','广东广州', '11',check ( (Tprof='教授' and Tsal>3500) or (Tprof='副教授' and。
2024-01-05 03:09:50
723
原创 触发器复习个人专用
SELECT '刘伟' AS "教师姓名",2018 AS "学年",IFNULL(@CourseHours,0) AS。SELECT '王一凡' AS "教师姓名",2016 AS "学年",IFNULL(@CourseHours,0)SELECT '2016115101' AS "学号",2017 AS "学年", 2 AS "学期",SELECT '2014112104' AS "学号",2014 AS "学年", 1 AS "学期",值段)以及尚未考试的学生人数,如(100~90,2人;
2024-01-05 03:08:39
1307
2
空空如也
按照编写jsp文件编写,别人版本是老版本,我的是新版本,不知道哪里出现了错误
2022-03-04
TA创建的收藏夹 TA关注的收藏夹
TA关注的人