SQL>insert into employee(empno) select empno from emp order by empno; SQL>commit;
第四步:根据emp.empno向employee导入ename,sal,job,mgr字段,此时将用到子查询批量更新 SQL>update employee a set (ename,sal,job,mgr)=(select ename,sal,job,mgr from emp b where a.empno=b.empno); SQL>commit;