SQL UPDATE

The UPDATE statement in SQL is used to modify existing records in a table. This powerful Data Manipulation Language (DML) command allows developers to update one or multiple rows simultaneously.

Syntax

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

• table_name: The name of the table containing the data to be updated.
• SET: Specifies the columns to update and their new values.
• condition: An optional clause that specifies which rows to update. If omitted, all rows in the table are updated.

Example

Let’s say there’s a table Employees:

To update Bob’s salary in the Sales department, the following query can be used:

UPDATE Employees
SET Salary = 47000
WHERE Name = 'Bob' AND Department = 'Sales';

Copy to clipboard
Copy to clipboard

Now, the updated table will be as follows: