用子查询更新数据

1、更新关联数据

update emp set (job,sal,comm)=(

select job,sal,comm from emp where ename='SMITH')

where ename='SCOTT';

 

2、复制表数据

update employee set deptno=

   (select deptno from emp where empno=7788)

where job=(select job from emp where empno=7788);

//将同7788员工岗位相同的员工都划入7788员工所属部门