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.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL snippets
Cosmo
Sign Up Now
or Subscribe for future quizzes