数据库批量更新 删除

--批量更新
update stuMarkssetwrittenExam=(case whenwrittenExam<95 thenwrittenExam+5 else 100end);
update stuMarksset labExam=(casewhen labExam<95then labExam+5  
when labExam>=95 then 100
when labExam is null then 0end);
select * from stuMarks ;


--批量删除 删除学号是 s253_01 s253_02 这两名学生的成绩
delete from stuMarks wherestuNo='s253_01' or stuNo='s253_02';

delete  from stuMarks where stuNo=(case whenstuNo='s253_01' thenstuNo when stuNo='s253_02'then stuNo end);

delete from stuMarkswhere in('s253_01','s253_02');

select * fromstuMarks ;