SQL之插入、更新与删除

1. insert into dept (deptno,dname,loc) values(50,'cleaning','Toilet');
2. insert into dept values (50,'cleaning','Toilet'), (60,'cooking','Kitchen');
3. insert into dept_east (select * from dept where loc in('new york','boston'));
4. create table dept_2 as select * from dept where 1=0;
5. 通过创建视图，将插入动作限制在某几列中进行
6. create view deptnum as select deptno from dept; 后，执行
7. insert into deptnum values(60); //将会分别在dept和deptnum中插入“60”；
8. update emp set sal=sal*1.1 where deptno=20;
9. update emp set sal=sal*1.1 where empno in(select empno from emp_bonus);
10. update emp set sal=sal*1.1 where exists(select null from emp_bonus where emp.empno=emp_bonus.empno);
11. 
    
12. update emp e set (e.sal,e.comm) =
13. (select ns.sal, ns.sal/2 from new_sal ns where ns.empno=e.empno )
14. where exists(select null from new_sal ns where ns.empno=e.empno );
15. 
    
16. delete from emp;
17. delete from emp where deptno=10;
18. delete from emp where empno=7792;
19. delete from emp e where not exists (select null from dept d where e.deptno=d.deptno);
20. delete from emp where deptno not in(select deptno from dept);
21. delete from dupes where id not in(select min(id) from dupes group by name);
22. 
    
23. delete from emp where deptno in
24. (select deptno from dept_accidents group by deptno having count(*)>=3);