SQL UPDATE Statement: Syntax, Usage, and Examples

The SQL UPDATE statement lets you modify existing data in a table. You can use it to change one field, multiple fields, or even apply updates conditionally. It’s one of the most powerful tools in SQL for maintaining accurate and current records.

In most cases, you use it to change existing records without touching the rest of the dataset.

How to Use the SQL UPDATE Statement

The basic syntax of an UPDATE statement in SQL looks like this:

UPDATE table_name
SET column1 = value1, column2 = value2
WHERE condition;

• UPDATE: The keyword that starts the update command in SQL.
• table_name: The table you want to update.
• SET: Specifies the column(s) and the new value(s).
• WHERE: Filters which rows to update.

Always use a WHERE clause unless you're deliberately updating all rows. Forgetting it can overwrite every row in the table.

A good habit is to double-check the name of the table before you run a query, especially in larger databases where similar table names can trip you up.

Here’s a simple example:

UPDATE employees
SET salary = 60000
WHERE employee_id = 5;

This changes the salary of the employee with ID 5. Without the WHERE clause, everyone would get the new salary.

You can also change a single column at a time when you only need to adjust one piece of data, which keeps the query easy to read.

When to Use the SQL UPDATE Statement

You’ll use the SQL UPDATE statement whenever you need to change data without deleting or inserting new records. Here are some common scenarios:

Fixing Incorrect Data

Maybe someone typed in the wrong value or imported bad data. You can use the SQL UPDATE statement to fix those records:

UPDATE products
SET price = 19.99
WHERE product_id = 102;

In a case like this, the new price becomes the updated value for that row.

Bulk Modifying Rows

You might want to increase salaries, adjust inventory, or update a status across many rows:

UPDATE orders
SET status = 'shipped'
WHERE order_date < '2024-01-01';

This kind of batch update is common in e-commerce and data cleanup tasks. It’s also a common way to change multiple rows with one statement instead of running the same query again and again.

Updating With Joins

Need to pull in data from another table? You can perform an SQL update using select and join:

UPDATE employees
SET department_name = d.name
FROM departments d
WHERE employees.department_id = d.id;

This is called an SQL UPDATE JOIN. It updates one table based on related data in another.

In many SQL systems, you may write this with an INNER JOIN when you only want matching rows from both tables.

Examples of the SQL UPDATE Statement

Example 1: Update a Record in SQL

UPDATE customers
SET phone = '123-456-7890'
WHERE customer_id = 1;

You’ve just corrected a customer’s phone number. Simple and direct.

If this row lives in a customers table, the query affects only the matching customer and leaves everyone else alone.

Example 2: SQL Update and Logic

You can combine conditions using AND to fine-tune your updates:

UPDATE inventory
SET quantity = quantity - 1
WHERE product_id = 10 AND quantity > 0;

This ensures you don’t reduce the stock below zero.

The quantity field here is an example of a column_name you target in an update query.

Example 3: SQL UPDATE From SELECT

Sometimes the new value you need comes from another query. Here’s a classic example of using update in SQL with JOIN and SELECT:

UPDATE employees
SET salary = (
  SELECT AVG(salary)
  FROM employees
  WHERE department_id = 2
)
WHERE department_id = 1;

This updates everyone in department 1 to have the average salary of department 2.

That average becomes the new column value written into the salary field for each matching row.

Example 4: Updating Multiple Columns

UPDATE users
SET last_login = NOW(), status = 'active'
WHERE user_id = 42;

You can update multiple fields at once. This helps reduce the number of queries and speeds up processing.

In other words, you can update multiple columns in one statement instead of splitting the work into separate queries.

Learn More About the SQL UPDATE Statement

UPDATE Syntax SQL Best Practices

The general structure is always:

UPDATE table
SET column = value
WHERE condition;

But keep these tips in mind:

• Always include a WHERE clause unless you're updating everything.
• Use transactions if you’re updating large data sets. That way, you can roll back if something goes wrong.
• Preview your WHERE clause with a SELECT statement first.

SELECT * FROM users WHERE status = 'inactive';

Then run:

UPDATE users SET status = 'archived' WHERE status = 'inactive';

Update Query in SQL With Joins

Some databases like PostgreSQL and SQL Server support joins directly in UPDATE queries:

UPDATE sales
SET region = r.name
FROM regions r
WHERE sales.region_id = r.id;

Others like MySQL use a slightly different syntax:

UPDATE sales
JOIN regions ON sales.region_id = regions.id
SET sales.region = regions.name;

Both achieve the same goal: an SQL update using select logic across tables.

This pattern often depends on a foreign key that links one table to another.

SQL Update Using Select in Subqueries

If joins feel too complex, you can use subqueries to pull in values:

UPDATE employees
SET manager_id = (
  SELECT id FROM managers WHERE name = 'Jordan'
)
WHERE department = 'Engineering';

You can think of this as a lookup table built into the query.

Using Update With SQL Functions

You can combine updates with built-in SQL functions to manipulate data:

UPDATE customers
SET email = LOWER(email)
WHERE email IS NOT NULL;

Or:

UPDATE orders
SET order_date = NOW()
WHERE order_date IS NULL;

This makes it easy to clean or normalize your data.

Update Command in SQL vs Insert

You might wonder when to update versus when to insert. If a record already exists and you want to modify it—use UPDATE. If it doesn’t exist yet—use INSERT. Some databases offer UPSERT or MERGE statements that can handle both at once.

INSERT INTO users (id, name)
VALUES (1, 'Taylor')
ON CONFLICT (id)
DO UPDATE SET name = 'Taylor';

This is a hybrid of insert and update.

SQL UPDATE with Conditions on Joined Tables

You can even use conditions from both tables when performing an update join:

UPDATE employees
SET bonus = 1000
FROM performance_reviews
WHERE employees.id = performance_reviews.employee_id
AND performance_reviews.rating = 'excellent';

That’s powerful—you’re using joined logic to selectively update rows.

Updating Based on Aggregated Data

Sometimes you want to update using GROUP BY or aggregate values. Here's one way to do it:

UPDATE products
SET stock = stock + temp.new_stock
FROM (
  SELECT product_id, SUM(quantity) AS new_stock
  FROM incoming_shipments
  GROUP BY product_id
) AS temp
WHERE products.id = temp.product_id;

This approach uses a subquery to summarize, then joins it back for the update.

The SQL UPDATE statement gives you full control over existing data. Whether you're fixing a typo, changing a status, syncing data from another table, or applying business rules, UPDATE gets the job done.