1.3.7.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 8 行

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'
)