LU08d - SQL-DML: DELETE

Sources:

• W3Schools | DELETE

The DELETE command is used to remove records from a table. Like UPDATE, it can be run with or without a filter, making it vital to define the condition to avoid unintended data removal.

Using a WHERE clause ensures that only specific rows matching the condition will be deleted.

Syntax:

DELETE FROM table_name 
WHERE condition;

Example

DELETE FROM employees 
WHERE employee_id = 1;

Omitting the WHERE clause removes all data from the table, so it must be used cautiously. This operation doesn’t remove the table structure, just the rows.

Syntax:

DELETE FROM table_name;

Example:

DELETE FROM employees;

Volkan Demir