SQL UPDATE Statement – Complete Beginner's Guide with Examples (2026-27)

✅ What is SQL UPDATE?

The SQL UPDATE statement is used to change the values of one or more columns in existing rows of a table. It is one of the four core DML (Data Manipulation Language) operations in SQL alongside SELECT, INSERT, and DELETE.

✅ UPDATE modifies existing rows — it does NOT add new rows (that is INSERT) or remove rows (that is DELETE).

✅ The WHERE clause controls which rows are updated. Without it, ALL rows in the table are updated.

✅ SQL UPDATE Syntax

✅ Basic Syntax:-

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

✅ UPDATE:- Specifies the table you want to modify.

✅ SET:- Lists the columns and their new values, separated by commas.

✅ WHERE:- Filters which rows to update. Without WHERE, ALL rows are updated.

✅ SQL UPDATE – Quick Reference Table

✅ Example 1 – Update One Column

Update POOJA's salary from 9000 to 11000:

UPDATE Employees
SET Salary = 11000
WHERE Name = 'POOJA';

✅ Result Show:-

✅ Example 2 – Update Multiple Columns at Once

Update SUJAN's salary AND city at the same time:

UPDATE Employees
SET Salary = 9500, City = 'Bangalore'
WHERE ID = 4;

✅ Result Show:-

✅ Example 3 – Update All Rows in a Department

Give every SALES employee a 1000 salary increase:

UPDATE Employees
SET Salary = Salary + 1000
WHERE Department = 'SALES';

✅ Result Show:-

Both RAJ (5000 → 6000) and MEENA (12000 → 13000) were updated because both are in SALES department.

✅ Example 4 – UPDATE with AND Condition

Update department to 'IT' only for employees in Pune with salary above 8000:

UPDATE Employees
SET Department = 'IT'
WHERE City = 'Pune' AND Salary > 8000;

✅ Result Show:-

✅ Example 5 – ⚠️ Dangerous: UPDATE Without WHERE

This example shows what happens when you forget the WHERE clause:

-- THIS UPDATES EVERY SINGLE ROW IN THE TABLE!
UPDATE Employees
SET Department = 'IT';

✅ Result Show (ALL rows changed – disaster!):-

-- Step 1: Preview which rows will be affected
SELECT * FROM Employees WHERE Department = 'SALES';

-- Step 2: Only THEN run the UPDATE
UPDATE Employees
SET Salary = Salary + 1000
WHERE Department = 'SALES';

✅ Key Points to Remember

• ✅ Always use WHERE — without it, every row in the table is updated.
• ✅ Test with SELECT first — run SELECT * FROM table WHERE your_condition before UPDATE to preview affected rows.
• ✅ Update multiple columns by separating them with a comma in SET: SET col1 = v1, col2 = v2.
• ✅ Use calculations in SET — SET Salary = Salary + 1000 adds 1000 to the current value.
• ✅ Use AND / OR to combine multiple conditions in WHERE for precise targeting.
• ✅ Columns not listed in SET stay unchanged — UPDATE only modifies the columns you specify.
• ✅ Use ID in WHERE when possible — WHERE ID = 4 targets exactly one unique row, the safest option.

✅ Common SQL UPDATE Mistakes to Avoid