Updating Records

The update statement is used to update or change records that match a specified criteria. This is accomplished by carefully constructing a where clause.

update "tablename"
set "columnname" = "newvalue" where "columnname" OPERATOR "value"
                                                 [and|or "column"
                                                    OPERATOR "value"];

Example:

1.
update "school"

set  name="rakesh" where number=2

2.
update "school"

set name="rakesh" where number=2 and lastname="reddy"