Why UPDATE with expressions in SQL? - Purpose & Use Cases

The Big Idea

What if you could change hundreds of prices with just one simple command?

The Scenario

Imagine you have a big list of products with prices in a spreadsheet. You want to increase all prices by 10%. Doing this by hand means opening each row and typing the new price one by one.

The Problem

Manually changing each price is slow and boring. It's easy to make mistakes, like typing the wrong number or missing some rows. If you have hundreds or thousands of products, this becomes a huge headache.

The Solution

Using UPDATE with expressions in SQL lets you change many rows at once by calculating new values automatically. You can tell the database to increase prices by 10% in one simple command, saving time and avoiding errors.

Before vs After

✗ Before

Update each price cell manually in the spreadsheet.

✓ After

UPDATE products SET price = price * 1.10;

What It Enables

This lets you quickly and safely adjust data in bulk, making your work faster and more reliable.

Real Life Example

A store owner wants to raise all product prices by 10% because of increased costs. Instead of editing each price, they run one SQL command to update all prices instantly.

Key Takeaways

Manual updates are slow and error-prone.

UPDATE with expressions automates bulk changes.

It saves time and reduces mistakes.