某数据库中有如下学生成绩表Score Id为整型、主键、自增
*
1添加一条成绩信息∶姓名StuName为王磊,科目名称Subject为Java编程,成绩Result为92
insert into score(StuName,Subject,Result) Values(‘王磊’,‘Java编程’,92);
2删除科目为语文的成绩信息
delete from score where subject =‘语文;3将学生姓名StuName为李红的成绩改为76update score set result= 76
3 将学生姓名StuName为李红的成绩改为76
Update Score Set Result= 76 Where Stuname = ‘李红’
4 查询成绩Score大于等于80的所有信息
*Select * From Score Where Result >= 80;