题解 | #将所有获取奖金的员工当前的薪水增加10%#

本题考查了更新语句UPDATE TABLE SET COLUMN_NAME的用法

# 题目：写出更新语句，将所有获取奖金的员工当前的(salaries.to_date='9999-01-01')薪水增加10%，
# (emp_bonus里面的emp_no都是当前获奖的所有员工)
# 方式一：连接两张表后的临时表，对临时表进行字段的SET修改;
# UPDATE emp_bonus AS eb INNER JOIN salaries AS s ON eb.emp_no = s.emp_no
# SET salary = salary * 1.1
# WHERE to_date = "9999-01-01"
# 方式二：子查询，通过salaries的emp_no,关联子表（emp_bonus）所得出的emp_no
UPDATE salaries AS s
SET salary = salary * 1.1
WHERE to_date = "9999-01-01"
AND s.emp_no IN (SELECT emp_no from emp_bonus)