The user can update the existing data with an UPDATE statement.
The user can update with specifying condition using following general syntax:
UPDATE table_name SET attribute1=value1, attribute2=value2, ....WHERE filter condition
When the UPDATE statement is executed, all the attribute columns that satisfy the specified filter condition will be updated to the new values.
The user can also updating the record by specifying the key in the dimension table.
The general syntax is following:
UPDATE table_name KEY(specified key) SET attribute1=value1, attribbute2=value2, ...
An update on KEY attribute column is not allowed.
After ABC company completed its database. One of its member, Julia Kennedy, notified the staff that she moved from Florida to Ohio. ABC company staff pulls out Customer table and identifies Julia Kennedy's original record as following:
The staff can use either of following two commands to revise Julia Kennedy's record:
UPDATE Customer SET state=Ohio WHERE name='Julia Kennedy'
UPDATE Customer KEY('4') SET state=Ohio
Julia Kennedy's record will be revised to be following: