Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

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
  1. UPDATE tablename SET column1=value

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

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


Examples:
  1. UPDATE tbl_emp SET emp_no=12345

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

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