SQL Command UPDATE

The UPDATE command has the following specification:

UPDATE TableName

SET field1 =’value1’ ... [, fieldN =’valueN’ ]

[WHERE logical_expresion]

where:

TableName – specify the name of the table for which the command is applied.

field1 =’value1’,..., fieldN =’valueN’ – pairs of (name, value) for the update clause.

At least one pair is necessary for the update command to succeed.

Name of the fields are in ASCII format, but the values could be in Unicode.

Only fields listed in the command with the associated values are updated. It is not necessary to list all the fields in the table.

logical_expresion – the logical expression that defines the set of rows on which the update command applies.

Examples

update errors set log="1"

update params set value="15" where name="BuzzerVolume"