前提背景:
想要更新分数表中的某个学生某一门科目的分数(最后一行71—>90)
更新学生成绩时,需要约束条件,可能会用到update嵌套查询
刚开始我使用了
update grade set score=90
WHERE cid=(SELECT grade.cid FROM course,grade where cteacher=66666
AND sid =1950722008
and course.cid = grade.cid)
会产生报错
方法:
update嵌套的select中不能直接select column from table
而是要select column from (select column from table) as tmp
具体代码如下
update grade set score=90
WHERE cid=(SELECT a.cid FROM (SELECT * from course WHERE course.cteacher=66666) a)
AND grade.sid =1950722008