SQL Update Statement
Table Of Contents:
- What Is SQL Update Statement?
- Syntax Of Update Statment.
- Examples Of Update Statement.
(1) What Is SQL Update Statement ?
- The
UPDATE
statement is used to modify the existing records in a table. - If the user wants to update their records at a later point in time they can do that using the “UPDATE” statement.
![](https://www.praudyog.com/wp-content/uploads/2023/04/55.png)
(2) Syntax Of SQL Update Statement.
Syntax:
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
(3) Examples Of SQL Update Statement.
Demo Data:
![](https://www.praudyog.com/wp-content/uploads/2023/04/11-1024x390.jpg)
Example-1: Updating A Single Record
UPDATE Customers
SET ContactName='Alfred Schmidt', City='Frankfurt'
WHERE CustomerID=1;
![](https://www.praudyog.com/wp-content/uploads/2023/04/56-1024x406.jpg)
Example-2: Updating Multiple Records
UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';
![](https://www.praudyog.com/wp-content/uploads/2023/04/57-1024x395.jpg)
Example-3: Update Warning!
UPDATE Customers
SET ContactName='Juan';
![](https://www.praudyog.com/wp-content/uploads/2023/04/58-1024x371.jpg)
Note:
- Be careful when updating records. If you omit the
WHERE
clause, ALL records will be updated!