[SQL 활용] 7. 데이터조작어( DML ) - UPDATE 구문

UPDATE

문법

UPDATE tabe
SET column = value [ , column = value, ... ]
[ WHERE condition ];

---

SELECT employee_id, department_id
FROM employees
WHERE employee_id = 113;

---

UPDATE employees
SET department_id = 50
WHERE employee_id = 113;

---

SELECT employee_id, department_id
FROM employees
WHERE employee_id = 113;

---

commit;

---

DESC copy_emp

---

UPDATE copy_emp
SET department_id = 110;

---

SELECT employee_id, department_id
FROM copy_emp;

---

rollback;

---

SELECT employee_id, department_id
FROM copy_emp;

---

SELECT employee_id, job_id, salary
FROM copy_emp
WHERE employee_id IN (113, 205);

 

---

-- 205번 사원도 113번과 같이 맞춰주기
UPDATE copy_emp
SET job_id =
            ( SELECT job_id
              FROM copy_emp
              WHERE employee_id = 205 ),
     salary = ( SELECT salary
                FROM copy_emp
                WHERE employee_id = 205 )
WHERE employee_id = 113;