- 1
- 0
- 约2.23千字
- 约 36页
- 2021-06-16 发布于河北
- 举报
八.操作数据-DML语句;目标;;
;INSERT INTO table [(column [, column...])]
VALUES (value [, value...]);;;
;
;
;
;
;INSERT INTO
(SELECT employee_id, last_name,
email, hire_date, job_id, salary,
department_id
FROM employees
WHERE department_id = 50)
VALUES (99999, Taylor, DTAYLOR,
TO_DATE(07-7月-99, DD-MON-RR),
ST_CLERK, 5000, 50);
1 row created.;
;UPDATE table
SET column = value [, column = value, ...]
[WHERE condition];;;
;SQL UPDATE employee
2 SET deptno = (SELECT deptno
3 FROM emp
4 WHERE empno = 7788)
5 W
原创力文档

文档评论(0)