Seth Woolley's Man Viewer

Manual for update - man update

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

UPDATE(7)                        SQL Commands                        UPDATE(7)



NAME
       UPDATE - update(7,n) rows of a table


SYNOPSIS
       UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...]
           [ FROM fromlist ]
           [ WHERE condition ]


DESCRIPTION
       UPDATE  changes  the  values  of the specified columns in(1,8) all rows that
       satisfy the condition. Only the columns to be  modified  need  be  men-
       tioned in(1,8) the statement; columns not explicitly SET retain their previ-
       ous values.

       By default, UPDATE will update(7,n) rows in(1,8) the specified table and all  its
       subtables. If you wish to only update(7,n) the specific table mentioned, you
       must use the ONLY clause.

       You must have the UPDATE privilege on the table to update(7,n) it,  as  well
       as  the  SELECT  privilege  to  any  table whose values are read(2,n,1 builtins) in(1,8) the
       expressions or condition.

PARAMETERS
       table  The name (optionally schema-qualified) of the table to update.

       column The name of a column in(1,8) table.

       expression
              An expression to assign to the column. The  expression  may  use
              the old values of this and other columns in(1,8) the table.

       DEFAULT
              Set  the  column  to its default value (which will be NULL if(3,n) no
              specific default expression has been assigned to it).

       fromlist
              A list of table expressions, allowing columns from other  tables
              to appear in(1,8) the WHERE condition and the update(7,n) expressions.

       condition
              An  expression  that returns a value of type boolean.  Only rows
              for which this expression returns true will be updated.

OUTPUTS
       On successful completion, an UPDATE command returns a  command  tag  of
       the form

       UPDATE count

       The count is the number of rows updated. If count is 0, no rows matched
       the condition (this is not considered an error(8,n)).

EXAMPLES
       Change the word Drama to Dramatic in(1,8)  the  column  kind  of  the  table
       films:

       UPDATE films SET kind = 'Dramatic' WHERE kind = 'Drama';


       Adjust temperature entries and reset(1,7,1 tput) precipitation to its default value
       in(1,8) one row of the table weather:

       UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT
         WHERE city = 'San Francisco' AND date = '2003-07-03';


COMPATIBILITY
       This command conforms to the SQL standard. The FROM clause is  a  Post-
       greSQL extension.



SQL - Language Statements         2003-11-02                         UPDATE(7)

References for this manual (incoming links)