[DML-DELETE] 데이터 삭제

DELETE

 

- 테이블의 데이터를 삭제

DELETE [FROM] Table
[WHERE 조건식];

 

DELETE
FROM countries
WHERE country_id = 'KP';

DELETE
FROM countries
WHERE country_id = 'KR';

DELETE
FROM departments
WHERE department_id = 280;

DELETE
FROM departments
WHERE department_id = 290;

DELETE
FROM jobs
WHERE job_id = 'IT QA';

DELETE
FROM jobs
WHERE job_id = 'IT DA';