The DELETE FROM statement is used to remove records from a table.

Basic Syntax

DELETE FROM person
WHERE person_id = 3;

Delete the person with ID 3.

Deleting All Rows

To delete all rows from a table (use with caution):

DELETE FROM person;

This removes all records from the table while keeping the table structure intact.