The Update command is used to make changes to records in tables. The general syntax is as under.

Syntax:
UPDATE table_name
SET Column1 = Value1, Column2 = Value2,…
WHERE Some_Column = Some_Value

Example:

Table(empinfo)

UPDATE empinfo
SET Phone = '421 873-1432'
WHERE FirstName = 'Steve'

If we don’t specify a WHERE clause in the SQL expression above, all employee’s Phone will be updated to '421 873-1432', so be careful with the SQL UPDATE command usage.