Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       DELETE -

SYNOPSIS

       DELETE FROM [ ONLY ] table [ WHERE condition ]

DESCRIPTION

       DELETE  WHERE   WHERE

              Tip: : TRUNCATE [truncate(7)]  PostgreSQL

         DELETE   ONLY

         DELETE  SELECT  condition

PARAMETERS

       table

       condition
                boolean

OUTPUTS

        DELETE

       DELETE count

         count   count  0 condition

EXAMPLES

        filmsmusicals

       DELETE FROM films WHERE kind <> 'Musical';

         films

       DELETE FROM films;

COMPATIBILITY

         SQL

       Postgresql  <laser@pgsqldb.org>