Delete

SQL DELETE

The DELETE command is used to delete records from an SQL table.
You can delete all records or only certain records from table.

Syntax

DELETE FROM name_of_table WHERE {condition}

Example

DELETE FROM students WHERE student_id=1 AND name='Tom';