DELETE(7)                        SQL Commands                        DELETE(7)

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 <?><?>
        <?><?><?><?><?><?><?>films<?><?><?><?><?><?><?><?>musicals<?><?>

       DELETE FROM films WHERE kind <> 'Musical';


        <?><?><?> films<?>

       DELETE FROM films;


COMPATIBILITY <?><?><?>
        <?><?><?><?><?><?> SQL <?><?><?>

<?><?>
       Postgresql <?><?><?><?> <?><?><?> <laser@pgsqldb.org>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

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