Updating Database Data Using SQL UPDATE statement

Updating Database Data Using SQL UPDATE statement. In this section, I will show you how to update data using SQL.

 

SQL UPDATE Syntax:

UPDATE table_name
SET col1 = value1, col2 = value2
WHERE condition;

Example:

UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;

UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';