- /*
- 数据的更新
- 增加
- 删除
- 修改
- */
- -----------------------------------增加(一次只能插入一条数据)
- --自定义插入数据列的顺序
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES(8888,'DFBB',2666,10);
- --按照数据库默认的顺序插入
- INSERT INTOEMPVALUES(9999,'RWX','JIAOZHU',7788,SYSDATE,3333,NULL,10);
- --插入查询的结果
- INSERT INTOEMP(EMPNO,ENAME)SELECTDEPTNO,DNAMEFROM DEPT;
- CREATE TABLEEMPCOPYAS SELECT * FROMEMPWHERE 1=2;
- --SQL注入(将来写代码的时候要防止sql注入)
- SELECT * FROMEMPWHEREJOB= 'CLERK' OR 1 = 1;
- --错误的示范
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES(8888,'DFBB',2666);
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES(8888,'DFBB',2666,10,2);
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES('abcd','DFBB',2666,10);
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES(56789,'DFBB',2666,10);
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES('1234','DFBB',2666,10);
- INSERT INTOEMP(EMPNO,ENAME,SAL,DEPTNO)VALUES(567,'DFBB',2666,10);
- -----------------------------------删除
- DELETE FROM EMP;
- DELETE FROMEMPWHEREEMPNO= '7788';
- DELETE FROMEMPWHEREENAMELIKE '%S%' ANDSAL>2000;
- --有毒 慎用
- CREATE TABLEEMPCOPYAS SELECT * FROM EMP
- TRUNCATE TABLE EMPCOPY;
- -----------------------------------修改
- UPDATEEMPSETSAL=SAL+1000,COMM= 800,JOB= 'CODER';
- UPDATEEMPSETSAL=SAL*1.2 WHEREEMPNO= 7788;
- UPDATEEMPSETSAL=SAL*1.2 WHEREENAMELIKE '%A%' ANDSAL<2000;
- ROLLBACK;
来源: http://www.bubuko.com/infodetail-2096274.html