Skip to main content

DELETE

Learn DELETE (CRUD Operations, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction DELETE removes rows that match a condition: DELETE FROM table WHERE condition . It is DML, fully transactional, logged row by row, fires triggers and respects foreign keys. Without WHERE it deletes every row (slowly); use TRUNCATE to empty a table fast.

More lessons in CRUD Operations