SQL - INSERT / UPDATE / DELETE

1) INSERT: 행 삽입하기 

INSERT INTO DEPARTMENTS(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID) 
VALUES (271, 'Sample_Dept', 200, 1700); 

INSERT INTO DEPARTMENTS 
VALUES (272, 'Sample_Dept', 200, 1700); 

commit;

 

2) UPDATE: 행 갱신하기

'Sample_Dept' 부서의 ID를 업데이트 
UPDATE DEPARTMENTS SET MANAGER_ID = 201, LOCATION_ID = 1800 
WHERE DEPARTMENT_NAME = 'Sample_Dept'; 

SELECT * FROM DEPARTMENTS;
COMMIT;

-- 서브쿼리를 사용하여 대량의 데이터를 변경 
UPDATE DEPARTMENTS 
SET (MANAGER_ID, LOCATION_ID) = (SELECT MANAGER_ID, LOCATION_ID        
								FROM DEPARTMENTS                                  
								WHERE DEPARTMENT_ID = 40) 
WHERE DEPARTMENT_NAME = 'Sample_Dept'; */

 

3) DELETE: 행 삭제하기

DELETE FROM DEPARTMENTS
WHERE DEPARTMENT_ID IN (SELECT DEPARTMENT_ID
                        FROM DEPARTMENTS
                        WHERE DEPARTMENT_NAME = 'Sample_Dept');
Commit;


SELECT * FROM DEPARTMENTS;