SQL DELETE Statement

SQL DELETE Statement

The DELETE statement is used to delete records(rows) in a table.

Syntax

DELETE FROM table_name
WHERE some_column=some_value;

Note

Notice the WHERE clause in the SQL DELETE statement! The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!
Read more.
WHERE-clause DELETE-statement

Follow Quizful

Send Feedback