Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       UPDATE -

SYNOPSIS

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

DESCRIPTION

       UPDATE / / SET

        UPDATE   ONLY

        UPDATE   expression  condition SELECT

PARAMETERS

       table

       column
                table /

       expression
               /

       DEFAULT
                NULL

       fromlist
               / WHERE

       condition
                boolean  true

OUTPUTS

        UPDATE

       UPDATE count

        count   count  0  condition

EXAMPLES

         films  kind  Drama Dramatic

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

         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

         SQL FROM  PostgreSQL

       Postgresql  <laser@pgsqldb.org>