SQL DELETE Statement

A SQL DELETE Statement is a Delete Data Manipulation Statement that is a SQL data manipulation statement (in the SQL language).

• Context:
  • It can take the form:
    • DELETE FROM table WHERE ...;
• Example(s):
  • DELETE FROM t1 WHERE id IN (value1, value2, value3, value4, value5);
• Counter-Example(s):
  • a SQL DROP TABLE Statement.
  • a SQL INSERT Statement.
  • a SQL INSERT Statement.
• See: SQL Data Querying Statement, Hash Data Manipulation Statement.

---

---

References

2013

• http://en.wikipedia.org/wiki/Delete_%28SQL%29
  • In the database structured query language (SQL), the DELETE statement removes one or more records from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some DBMSs, like MySQL, allow to delete rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE).

---