Database update
A database update is an operation that modifies existing records, rows, documents, or other stored data according to specified criteria.
Learn SQL in a Month of Lunches
An UPDATE statement is an SQL statement that modifies values in existing rows of a table, optionally subject to filtering conditions.
- How it is used
- Changes existing table values for corrections, data population, and targeted maintenance.
- How deep it goes
- Explains basic and multiple-column updates, NULL assignments, validation, and multitable filtering while deferring vendor-specific multitable syntax to RDBMS documentation.
- Examples
- Uses title price and royalty changes, author middle-name removal, customer address correction, and CategoryID population.
- What you can do after
- Apply it via SQL UPDATE statements to change selected rows after previewing matching data with SELECT.
Read how Learn SQL in a Month of Lunches explains database update →
Build Python Web Apps with Streamlit
UPDATE is a SQL statement that changes column values in rows matching an optional condition.
- How it is used
- Applies SQL changes to existing rows in a CRUD application database.
- How deep it goes
- Defines UPDATE and works through one conditional text change, but does not develop transaction or concurrency internals.
- Examples
- Uses the haikus table to prefix Alice’s haiku text and inspect the resulting row.
- What you can do after
- Apply UPDATE in PostgreSQL and verify a targeted row change with SELECT.
Read how Build Python Web Apps with Streamlit explains database update →
Spring in Action, Sixth Edition
The JdbcTemplate update method executes a SQL statement that writes or modifies database data and accepts values for its parameters.
- How it is used
- Uses JdbcTemplate to persist application data through repository save methods.
- How deep it goes
- Explains SQL parameters and contrasts update() with query(), but stops short of transaction handling or generated keys.
- Examples
- Demonstrates inserting an Ingredient row with three values supplied to an SQL statement.
- What you can do after
- Build it from scratch by implementing a repository save method that inserts domain-object values into a database.
Read how Spring in Action, Sixth Edition explains database update →
Also covered in
- Web Components in Action
- API Design Patterns
- ScyllaDB in Action
- Kotlin in Action, 2E
- Just Use Postgres!
- Python How-To
- Learn AI-Assisted Python Programming, Second Edition
- Learn Rust in a Month of Lunches
- Elasticsearch in Action, Second Edition
- Practical Automation with PowerShell: Effective scripting from the console to the cloud
- Terraform in Depth: Infrastructure as Code with Terraform and OpenTofu
- The Design of Web APIs, Second Edition
What to know first
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- attributeAn attribute is a named property or piece of information associated with an entity, object, or structured data item.
- deletionDeletion is an operation or request that removes an item, data, or resource from a collection or system.
- lambdaA lambda is an expression that defines an unnamed function, specifying its parameters and body and producing a callable value.
Related concepts
- batchingused by · Batching is the grouping of multiple items, requests, or operations so they can be processed together as a unit.
- CRUDpart of · CRUD is the set of data-management operations for creating, reading, updating, and deleting records or resources.
- custom methodalternative to · A custom method is a user-defined operation or capability added to an interface to provide behavior beyond its predefined functionality.
Questions about database update
What is database update?
A database update is an operation that modifies existing records, rows, documents, or other stored data according to specified criteria.
Which Manning books explain database update?
Learn SQL in a Month of Lunches, Build Python Web Apps with Streamlit and Spring in Action, Sixth Edition.
What should I know before learning database update?
Manning books that teach database update usually introduce SQL, attribute, deletion and lambda first.
What is the difference between database update and create function?
A database update is an operation that modifies existing records, rows, documents, or other stored data according to specified criteria. A provider create function is a lifecycle operation that creates a new resource and records its resulting state.
What is database update part of?
Database update is part of CRUD. CRUD is the set of data-management operations for creating, reading, updating, and deleting records or resources.
What is database update also called?
Database update is also called update statement, update method, update operation or updating.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.


