--3.4 SQL数据更新

--3.4 SQL数据更新
---insert
--insert into S values(''''''''........);
---update
update S  set AGE=22 where SNO='S3';

update S set AGE=AGE+1;

update SC set SCORE=0
where '计算机'=(select DEPT from S where SC.SNO=S.SNO);

---delete data

delete
from S
where SNO='S7';

delete
from SC;

delete from SC
Where '计算机'=(select DEPT from S where S.SNO=SC.SNO);