SQL Update Command
This command is used to make changes to records in tables. Syntax:
set columnname = newvalue [,columnxname = newvaluex...]
where columnname OPERATOR value [and|or columnnamex OPERATOR valuex];
The OPERATOR is one of the conditions listed on the Select Command page.
set population = population+1
where name = 'Argos' and
state = 'Indiana';