DELETE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
OUTPUTS è¾åº
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

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

---