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 →
Related concepts
- batchingused by · Batching is the grouping of multiple data items, requests, or operations so they can be processed together as a unit.
- where clausehas part · A WHERE clause is a query-language clause that restricts returned or affected records to those satisfying a specified predicate.
- missing valueuses · A missing value is a marker or condition indicating that an expected data value or reference is absent, unavailable, unknown, or inapplicable.
- set clausehas part · A SET clause specifies values or properties to assign or update in a data-manipulation statement.
- keywordkind of · A keyword is a language-defined word or token with a predefined syntactic or semantic role, often restricted from use as an ordinary identifier.
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.