- insert into dept (deptno,dname,loc) values(50,'cleaning','Toilet');
- insert into dept values (50,'cleaning','Toilet'), (60,'cooking','Kitchen');
- insert into dept_east (select * from dept where loc in('new york','boston'));
- create table dept_2 as select * from dept where 1=0;
- 通过创建视图,将插入动作限制在某几列中进行
- create view deptnum as select deptno from dept; 后,执行
- insert into deptnum values(60); //将会分别在dept和deptnum中插入“60”;
- update emp set sal=sal*1.1 where deptno=20;
- update emp set sal=sal*1.1 where empno in(select empno from emp_bonus);
- update emp set sal=sal*1.1 where exists(select null from emp_bonus where emp.empno=emp_bonus.empno);
- update emp e set (e.sal,e.comm) =
- (select ns.sal, ns.sal/2 from new_sal ns where ns.empno=e.empno )
- where exists(select null from new_sal ns where ns.empno=e.empno );
- delete from emp;
- delete from emp where deptno=10;
- delete from emp where empno=7792;
- delete from emp e where not exists (select null from dept d where e.deptno=d.deptno);
- delete from emp where deptno not in(select deptno from dept);
- delete from dupes where id not in(select min(id) from dupes group by name);
- delete from emp where deptno in
- (select deptno from dept_accidents group by deptno having count(*)>=3);
SQL之插入、更新与删除
最新推荐文章于 2022-04-26 18:11:15 发布