1.3.7.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

UPDATE CHOICES
SET SCORE=SCORE+5
WHERE CHOICES.NO=(
  SELECT CHOICES.NO
  FROM CHOICES,COURSES,STUDENTS
  WHERE COURSES.CID=CHOICES.CID AND STUDENTS.SID=CHOICES.SID AND COURSES.CNAME='c'
        AND STUDENTS.SNAME='zapyv'
)