Deletion

As explained in Build Python Web Apps with Streamlit

DELETE FROM is a SQL statement that removes rows from a table, optionally restricted by a condition.

DELETE FROM haikus WHERE haiku_id = 2;

How Build Python Web Apps with Streamlit covers it

How deep it goes

Explains WHERE targeting, warns that omitting it deletes every row, and distinguishes deleting rows from dropping a table.

Examples

Uses a DELETE FROM statement to remove the haiku with ID 2.

What you can do after

Apply SQL DELETE FROM with a WHERE condition to remove a chosen row.

How it connects

Connects row deletion to SQL WHERE conditions, UPDATE, and DROP TABLE.

liveBookmanning.com

Read Build Python Web Apps with Streamlit on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  Advanced Algorithms and Data StructuresDelete is an operation that removes a node or element from a data structure while preserving its structural invariants.
• 

  liveBookmanning.com
  Django in ActionDELETE is an HTTP method that requests removal of a resource identified by a URL.
• 

  liveBookmanning.com
  API Design PatternsA delete method is an API operation that removes an existing resource.
• 

  liveBookmanning.com
  Pro ASP.NET Core 7, Tenth EditionDelete is a response-cookie operation that instructs the client to remove a cookie.
• 

  liveBookmanning.com
  Building Web APIs with ASP.NET CoreDELETE is an HTTP request method for removing a resource.
• 

  liveBookmanning.com
  ASP.NET Core in Action, 3eRemove is an Entity Framework Core method that marks an entity for deletion when changes are saved.
• 

  liveBookmanning.com
  100 Java Mistakes and How to Avoid ThemA collection removal method is an operation that removes matching elements or mappings from a collection or map.

Compare how 8 books explain deletion →

Related concepts

• compactioncontrasts with · Compaction is the consolidation or reorganization of data, objects, or context to reduce length or fragmentation while preserving what is needed.
• list methodcontrasts with · A list method is a callable operation provided by a list or list-like collection for inspecting, querying, or modifying its contents.
• HTTP methodkind of · An HTTP method is a standardized operation token in an HTTP request that specifies the intended action on a resource.
• CRUDpart of · CRUD is the set of data-management operations for creating, reading, updating, and deleting records or resources.
• databaseuses · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
• Mapuses · A map is an associative data structure that stores key-value pairs and supports retrieving values by key.

This explainer was generated by Manning's knowledge graph from the text of Build Python Web Apps with Streamlit. The section links point to the parts of the book it draws on.