数据库原理背题篇：插入与视图

将学生插入表中：INSERT INTO student VALUES（'2023317220101','杨俊森'，'man','null'）

对每一个专业查询平均年龄并存入ag库中： INSERT INTO ag SELECT AVG(year(getdate())-year(Sbirthdate)) FROM student GROUP BY Smajor

建立表同时插入上一题的子结果：CREATE table ag as SELECT AVG(year(getdate())-year(Sbirthdate)) FROM student GROUP BY Smajor

修改一个元组的值：UPDATE student SET Ssex='man' WHERE Sname='mike'

将选修80001课程的学生分数减少5：UPDATE SC SET Grade=Grade-5 WHERE Cno='80001'

将计科学生的全体成绩改为0，UNDATE SC SET Grade=0 WHERE Sno IN (SELECT Sno FROM student WHERE Smajor ='计科')

删除学号为20180001学生的信息：DELETE FROM student WHERE Sno='20180001'

删除所有学生记录：DELETE FROM student

删除计科学生记录：DELETE FROM student WHERE Smajor='计科'

建立计科学生的视图：CREATE VIEW JK AS SELECT *FROM student WHERE Smajor='计科'

将学生的年龄与名字搞成一个视图：CREATE VIEW JK(Sname,Syear)AS  SELECT Sname year(getdate())-year(Sbirthdate) FROM student

将学生的年龄与名字搞成一个学会分组视图：CREATE VIEW JK(Sname,Syear)AS  SELECT Sname year(getdate())-year(Sbirthdate) Sno FROM student GROUP BY Sno

删除视图JK：DROP VIEW JK