SQL的类型
SQL的类型:
1.DML(data manipulation language 数据操作语言):insert update delete select
2.DDL(data definition language 数据定义语言):create table,alter table,drop table,truncate table,create/drop view,sequence(序列),index,synonym(同义词)
3.DCL(data control language 数据控制语言):grant(授权) revoke(插销权限).
insert 语句语法
insert into emp(empno,ename,sal,deptno) values (1001,'Tom',3000,10);
insert into emp(empno,ename,sal,deptno) values(&empno,&ename,&sal,&deptno);
create table emp10 as select * from emp where 1=2;
insert into emp10 select * from emp where deptno=10;
update employees set job_id =(select job_id from employees where employee_id=205),salary=(select salary from employees where employee_id=205) where employee_id=114;
delete和truncate的区别
1.delete逐条删除;truncate先摧毁表,在重建.
2.