UPDATE table in Teradata

You can update columns in a table by UPDATE command.

Syntax:
To set the value for all the records in a column
UPDATE tablename SET column1=value

To set the value for particular records in a column
UPDATE tablename SET column1=value WHERE condition

To set the value for multiple columns
UPDATE tablename SET column1=value1, column2=value2 ..... WHERE condition


Examples:
UPDATE tbl_emp SET emp_no=12345

UPDATE tbl_emp SET emp_no=12345 WHERE emp_name='Forgetter';

UPDATE tbl_emp SET emp_no=12345, phone_no=9876543210 WHERE emp_name='Forgetter';