插入 几条老师信息 和成绩、用SQL插入几条员工信息(注意:bit类型,在写代码中用1或0来表示,不要用’false’,会进行类型转换的。)
练习1:给studentId是1的英语成绩加10分
练习2:考试题偏难,所有人的成绩加5分
练习3:所有女学生的年龄减1岁
删除工资大于2000的老师
============将老师表清空========
删除所有老师
删除数据时候 把自增长列的值还原成种子
1.update TblScore set tEnglish=tEnglish+5 where studentId=1
2.(第一种方法)update TblScore set tEnglish=tEnglish+5 where tEnglish+5<=100
update TblScore set tMath=tMath+5 where tMath+5<=100
update TblScore set tEnglish=100 where tEnglish+5>=100
update TblScore set tMath=100 where tMath+5>=100
(第二种方法)
update Score
set english=
(
case when english+5<=100 then english+5
when english+5>=100 then 100
end
),
math=
(
case when math+5<=100 then math+5
when math+5>=100 then 100
end
)
3.update TblStudent set tTAge=tTAge-1 where tTGender='女'
4. delete from TblTeacher where tTSalary>2000
5. delete from TblTeacher
6. drop table TblTeacher
7.truncate table TblTeacher;
insert into TblTeacher VALUES('李四',1,20,10000,'2000-10-10');