SQL Commands

SQL UPDATE

The Update Statement

The UPDATE statement is used to modify the data in a table.

Syntax

Table name “Associate”

Update one Column in a Row

We want to add a Last name to the person with a First name of "Sunil”.

Result

Update several Columns in a Row

We want to change the address and add the name of the city:

Result