DELETE Statement

Jump to bottom

OneAndonlyFinbar edited this page Jan 22, 2022 · 4 revisions

The DELETE command can be used to delete certain rows of a table.

Syntax

DELETE
FROM [table]
[WHERE condition(s)]

Examples

Delete all rows

DELETE FROM table

Delete selected rows

DELETE FROM table WHERE column = 'value'