如何先取数再更新

update salaries sa join emp_bonus eb on eb.emp_no = sa.emp_no
set sa.salary = salary*1.1
where sa.to_date = "9999-01-01"

我本来是这么写的：update sa select salary from emp_bonus eb right join salaries sa on eb.emp_no = sa.emp_no set sa.salary = salary*1.1 where sa.to_date ="9999-01-01" 思路是对的，就是先取出来，然后计算好了，再更新回去，但是这样写语法不对，查了一下原来可以直接用update 代替from，就类似这样：

update salaries sa join emp_bonus eb on sa.emp_no = eb_emp_no

set sa.salary = salary *1.1

where sa.to_date = "9999-01-01"