大学计算机上机实验指导与测试(第6版)答案.docxVIP

实验二1.insert into Teachers2 values (600001,杨梦,女,54,#1986/04/22#,YES,2660,210)2.insert into Teachers2 (教师号,姓名,年龄) values (600002,罗贤兴,52)3.delete from Teachers2 where 姓名=关红梅4.delete from Teachers2 where 年龄40 and 性别=女5.update Teachers2 set 年龄=年龄+16.update Teachers2 set 应发工资=应发工资*1.2 where year(date())-year(参加工作年月)=153.4. 5. 6.8. 9. 10. 11. 12. 13. 14.