What is UPDATE? Meaning and example

What is UPDATE?

UPDATE: The statement that changes values in existing rows. A WHERE clause selects which rows; without it, every row changes. It is good practice to run the matching SELECT first. It runs inside a transaction and can be rolled back.

Level: beginnerTopic: SQL databases

UPDATE: an example

UPDATE products SET price_inr = price_inr * 1.05 WHERE category = 'snacks'; raises snack prices by 5 percent.

Related terms

INSERT
DELETE
WHERE
Transaction

More SQL databases terms

View
WHERE
Window frame
Window function
Write-ahead log
ACID
Aggregate function
ALTER TABLE

Where you learn it

UPDATE is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.