UPDATE table in Teradata

  1. Forget Code
  2. Teradata
  3. UPDATE table
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';