Teradata UPDATE Statement

Teradata UPDATE statement update columns of an existing table in Teradata. You can update one or more columns using a single UPDATE statement.

Teradata UPDATE Statement syntax

The general syntax for the Teradata UPDATE statement is as follows.

 To update all the records in a column

UPDATE DatabaseName.TableName
SET column_name = value;

To update specific records in column

UPDATE DatabaseName.TableName
SET column_name = value
WHERE condition;

To update multiple columns in a table

UPDATE DatabaseName.TableName
SET column1 = value1,
column2 = value2,
...
columnN = valueN
WHERE condition;

Teradata UPDATE Statement example

Consider the following employee table.

The below statement updates mgr columns for all the employees.

UPDATE Teradatapoint.tbl_employee
SET mgr=7902;

When the above query is executed it returns the following records.

The below example updates mgr for the employee whose empno is 6.

UPDATE Teradatapoint.tbl_employee
SET mgr=7902
WHERE empno=6;

And the below SQL statement updates both the mgr and job column.

UPDATE Teradatapoint.tbl_employee
SET mgr=7902,
job='Sr. Manager'
WHERE empno=6;