Live briefing
Everything about Delete (SQL)
SQL statement
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. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Delete (SQL)A 5-minute orientation
- Pick up a classic book: Database system conceptsThe most-reprinted book on the subject
- Read the landmark paper: An Extension of RETRO Framework: Translating SQL Insert, Update and Delete Queries to SPARQL UPDATECited 0 times
- Go sideways: Truncate (SQL)A closely related topic
- Go sideways: Database triggerA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
📚 Books worth reading
Database system conceptsAbraham Silberschatz · 1997
Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
Access database design & programmingSteven Roman · 1997
PHP for the World Wide WebLarry Ullman · 2001
Sams teach yourself SQL in 10 minutesBen Forta · 1999
Dreamweaver MXRay West, Thomas Muck · 2002
Data science from scratchJoel Grus · 2015
MongoDB and PHPSteve Francia · 2012
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Truncate (SQL) In SQL, the TRUNCATE TABLE statement is a data manipulation language (DML) operation that deletes all rows of a table without causing a triggered action…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- Foreign key A foreign key is a set of attributes in a table that refers to the primary key of another table, linking these two tables. In the context of relational…
- Data definition language In the context of SQL, data definition language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements…
- PL/SQL PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle…
- View (SQL) In a database, a view is the result set of a stored query that presents a limited perspective of the database to a user. This pre-established query command…
- Active record pattern In software engineering, the active record pattern is an architectural pattern. It is found in software that stores in-memory object data in relational…
- Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…