Updating Data in a Table

To update a column in a table, you use the Update statement. The Update statement requires that you define which column you are going to modify and the new value to place in the column. If you do not define selection criteria, a the columns in the table will be updated. The syntax of the update statement is

Update tableName Set columnNameValueList Where select_a_list

The column name value list is a comma separated list of column names and the new value. A single column name value pair looks like this:
Columnname = value

Domain Name Search