Lesson plan
Delete (SQL)
In the database structured query language (SQL), the DELETE statement is used to remove one or more rows from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some database management systems (DBMSs), like MySQL, allow deletion of rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE). It is not possible to delete individual values using , instead UPDATE should be used to set the value to . Backups should always be created before using .
Article summary
In the database structured query language (SQL), the DELETE statement is used to remove one or more rows from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some database management systems (DBMSs), like MySQL, allow deletion of rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE). It is not possible to delete individual values using , instead UPDATE should be used to set the value to . Backups should always be created before using .
Key claims
No claims recorded.
Discussion questions
- Summarise the article in your own words. Which single claim would you verify first, and why?
- Which claim in this article is most likely to be revised as the sources update? How would you check its current status?
- If two sources disagreed about one of these facts, what would you need in order to trust one over the other?
Bibliography
No sources recorded.
Key claims and bibliography are generated from the same tracked claims and sources as the article page.