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

DELETE 구문

문법

DELETE [ FROM ] table
[ WHERE condition ];

---

DELETE FROM departments
WHERE department_id = 270;

---

SELECT * FROM departments
ORDER BY department_id desc;

---

DELETE FROM copy_emp;

---

SELECT * FROM copy_emp;

---

rollback;

---

SELECT * FROM copy_emp;

---

commit;