SQL UPDATE Statement: Syntax, Examples, and Safe Patterns (2026)

The UPDATE statement is used to modify existing records in a table by changing the values of one or more columns.

Last updated: May 2026

Quick answer: Use UPDATE ... SET ... WHERE ... to change existing rows safely. Always validate the WHERE filter first, because omitting it updates every row in the table.

Want to test this safely on a real schema? Download DbSchema - a visual database design tool with a built-in SQL editor - and run UPDATE queries with visual table context, result previews, and rollback-friendly workflow.

Related SQL guides: SQL WHERE Clause, SQL DELETE Statement, SQL INSERT INTO SELECT

SQL UPDATE statement syntax

The basic syntax for the UPDATE statement is as follows:

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

• table_name: Name of the table where the records will be updated.
• column1, column2, ...: Columns that you want to modify.
• value1, value2, ...: New values that you want to assign to the specified columns.
• WHERE: Optional. Specifies which record(s) to update. If omitted, all records in the table will be updated.

UPDATE with a WHERE clause

Let's consider the following Students table:

To update the age of Alice to 23, you would run the following query:

UPDATE Students
SET Age = 23
WHERE Name = 'Alice';

Result: After running the query, the Students table will look like this:

Explanation: Here, the UPDATE statement modified the Age of Alice to 23 as specified in the SET clause. The WHERE clause is used to specify the record to be updated.

Design and visualize
your database schema

Edit referenced records
in related tables

Query your data
visually too

Reuse the SQL
generated

Free Download

UPDATE without a WHERE clause: what happens and how to avoid it

Without the WHERE clause, all records in the table would have been updated.

UPDATE Students
SET Age = 23;

Results:

Update single or multiple columns

As seen in the example above, the UPDATE statement can be used to modify a single data field. However, it can also be used to modify multiple data fields at once.

Let's say we want to update the Name of Alice to 'Alicia' and her Age to 24. The query would be:

UPDATE Students
SET Name = 'Alicia', Age = 24
WHERE StudentID = 2;

Result: After running the query, the Students table will look like this:

Explanation: In this case, both the Name and Age of the record with StudentID 2 were updated.

UPDATE with date and time functions

You can also use date-time functions in the SET clause of the UPDATE statement.

Let's consider the following Orders table:

To update the OrderDate of the first order to the current date, you can use the CURRENT_DATE function:

UPDATE Orders
SET OrderDate = CURRENT_DATE
WHERE OrderID = 1;

Result: After running the query, the Orders table will look like this:

Explanation: Here, the OrderDate of the first order was updated to the current date.

UPDATE with subqueries and JOIN

You can also use subqueries and JOIN statements in the UPDATE statement.

Let's consider the following two tables, Orders and OrderDetails:

Orders table:

OrderDetails table:

To update the Quantity in the OrderDetails table based on a condition in the Orders table, you can use a subquery or JOIN statement. Here, we will use a subquery:

UPDATE OrderDetails
SET Quantity = 50
WHERE OrderID IN (
    SELECT OrderID
    FROM Orders
    WHERE CustomerID = 'C1'
);

Result: After running the query, the OrderDetails table will look like this:

Explanation: Here, the Quantity of the first order was updated to 50 because the CustomerID of the first order in the Orders table is 'C1'.

Update a table with data from another table

You can update a table using data from another table.

Let's consider the following two tables, Customers and Orders:

Customers table:

Orders table:

To update the CustomerName in the Orders table using the CustomerName from the Customers table, you can use a subquery or JOIN statement. Here, we will use a JOIN statement:

UPDATE Orders
SET Orders.CustomerName = Customers.CustomerName
FROM Orders
JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Result: After running the query, the Orders table will look like this:

Explanation: Here, the CustomerName in the Orders table was updated using the CustomerName from the Customers table.

SQL Update Multiple Rows

The UPDATE statement can be used to update multiple rows at once.

Example

Let's consider the following Products table:

To increase the price of all products by 10%, you would run the following query:

UPDATE Products
SET Price = Price * 1.10;

Result: After running the query, the Products table will look like this:

Explanation: Here, the Price of all products was increased by 10%.

Update Data by Omitting WHERE Clause

If you omit the WHERE clause in the UPDATE statement, all records in the table will be updated.

Example

Let's consider the following Products table:

To update the Price of all products to 50, you would run the following query:

UPDATE Products
SET Price = 50;

Result: After running the query, the Products table will look like this:

Design and visualize
your database schema

Edit referenced records
in related tables

Query your data
visually too

Reuse the SQL
generated

Free Download

Explanation: Here, the Price of all products was updated to 50 because the WHERE clause was omitted.

Common Mistakes

• Forgetting the WHERE clause: If you forget to include the WHERE clause in the UPDATE statement, all records in the table will be updated. Always double-check your query before running it to avoid updating the entire table by mistake.
• Not backing up data: It's always a good idea to backup your data before running an UPDATE statement, especially if you are updating multiple records or working on a production database.

Try UPDATE queries safely in DbSchema

DbSchema helps you practice UPDATE statements without guessing which rows will change, because you can inspect tables, preview filters, and review relationships before you run anything destructive.

1. Download DbSchema and connect through the PostgreSQL JDBC driver, MySQL JDBC driver, or SQL Server JDBC driver.
2. Open the SQL Editor and run a SELECT with the same WHERE condition you intend for your UPDATE. That quick dry run confirms row scope before any rows change.
3. When you are satisfied with the filter, run the UPDATE. Prefer a scratch database or explicit transactions while you are learning, especially after the examples in this guide that omit WHERE on purpose.
4. If your change depends on related tables or foreign keys, use the Relational Data Explorer to verify linked rows, and check keys in the diagram view before join-style or correlated updates.
5. Share the outcome with teammates using exported schema documentation when you are aligning on production change windows.

This workflow mirrors how experienced teams validate updates: confirm the WHERE clause, understand dependencies, then execute.

FAQs

• Can I update multiple columns in a single UPDATE statement? Yes, you can update multiple columns in a single UPDATE statement by separating the column-value pairs with commas in the SET clause. For example: SET column1 = value1, column2 = value2, ....
• Can I update multiple tables in a single UPDATE statement? MySQL supports multi-table updates, while PostgreSQL and SQL Server typically update one target table per statement (even though they can join other tables in UPDATE ... FROM patterns). Always verify syntax and behavior for your specific database engine.

Practice Questions

1. Write an SQL query to update the Price of all products in the Products table to 100 if the Price is less than 50.
2. Write an SQL query to update the CustomerName in the Orders table using the CustomerName from the Customers table.
3. Write an SQL query to update the OrderDate of all orders in the Orders table to the current date.
4. Write an SQL query to increase the Quantity of all orders in the OrderDetails table by 10% if the OrderID is less than or equal to 10.

Conclusion

The SQL UPDATE statement modifies existing records in a table, allowing updates to single or multiple columns and rows, using date-time functions, subqueries, or JOIN statements. It can also update a table with data from another table. Always double-check your query and backup data before running an UPDATE statement, especially in a production database.

Mastering the UPDATE statement requires regular practice and real-world application. This guide is a starting point, but hands-on experience will solidify your understanding.

If you want to learn more, read the article about: DELETE Statement. INSERT Statement WHERE Clause JOINS Explained

Related Resources

• SQL UPDATE - W3Schools[1]
• UPDATE Statement - MySQL Docs[2]
• SQL Tutorial - GeeksforGeeks[3]

Happy Querying !!

Ready to try these statements against a real schema? Download DbSchema and run your next UPDATE in the SQL Editor, where the row count and the Commit and Rollback buttons tell you what the statement actually touched before you make it permanent.

Sources

1. SQL UPDATE - W3Schools
2. UPDATE Statement - MySQL Docs
3. SQL Tutorial - GeeksforGeeks