Deleting Data

DELETE Statement: Used to remove records from a table.

Syntax:

DELETE FROM table_name
WHERE condition;

Example:

DELETE FROM employees
WHERE employee_id = 1;

Explanation: This deletes the employee record with employee_id 1 from the employees table. The WHERE clause is crucial to avoid deleting all records.