UPDATE 更新数据库中的记录

将老师的薪水提高5%

UPDATE Teacher SET Salary = Salary * 1.05;

将计算机系的老师的薪水提高5%

UPDATE Teacher SET Salary = Salary * 1.05 WHERE DNumber in SELECT Dnumber FROM Dept WHERE Dname = "计算机";