¾�ΥС�������ʸ�� �� 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2

DELETE

Name

DELETE  --  �ơ��֥뤫��Ԥ���

Synopsis

DELETE FROM [ ONLY ] table [ WHERE condition ]
  

����

table

��¸�Υơ��֥�̾�Ǥ� (�������޽���̾�Ǥ��)��

condition

������٤��Ԥ��֤���SQL �������䤤��碌�Ǥ���

WHERE��ˤĤ��ƤΤ��ܺ٤ˤĤ��Ƥϡ�SELECTʸ�򻲾Ȥ��Ʋ�������

����

DELETE count

�Ԥ�����˺�����줿�����֤�����å������Ǥ��� count �Ϻ�����줿�Կ��򼨤��ޤ���

count �� 0 �ξ�硢�������Ԥ��ʤ��ä����Ȥ򼨤��ޤ���

����

DELETE �ϻ��ꤷ���ơ��֥뤫�� WHERE ����������Ԥ������ޤ���

condition (WHERE ��) ���ʤ���硢���ꤷ���ơ��֥�����ƤιԤ������뤳�Ȥˤʤ�ޤ������η�̤�¸�ߤ����ΤΡ���Ȥ����Υơ��֥�ˤʤ�ޤ���

Tip: PostgreSQL �γ�ĥ�Ǥ��� TRUNCATE �ϡ�����®�ˡ��ơ��֥뤫�����ƤιԤ������뵡�����󶡤��ޤ���

�ǥե���Ȥǡ�DELETE �ϻ��ꤵ�줿�ơ��֥�ڤӤ��Υ��֥ơ��֥�Τ��٤ƤΥ��ץ�������ޤ������ꤵ�줿�ơ��֥�Τߤ򹹿�����������ONLY�����Ѥ��Ʋ�������

�ơ��֥���ѹ����뤿��ˤϽ񤭹��߸��¤�ɬ�פǤ��� ���碌�ơ�condition ���ɤ߹��ޤ���ͤ���ĥơ��֥�ؤ��ɤ߹��߸��¤�ɬ�פˤʤ�ޤ���

������ˡ

�ơ��֥� films ���� musical �ʳ������ƺ������ˤϡ��ʲ��Τ褦�ˤ��ޤ���

DELETE FROM films WHERE kind <> 'Musical';
SELECT * FROM films;

 code  |          title            | did | date_prod  |  kind   | len
-------+---------------------------+-----+------------+---------+-------
 UA501 | West Side Story           | 105 | 1961-01-03 | Musical | 02:32
 TC901 | The King and I            | 109 | 1956-08-11 | Musical | 02:13
 WD101 | Bed Knobs and Broomsticks | 111 |            | Musical | 01:57
(3 rows)

�ޤ����ơ��֥� films ����ˤ���ˤϡ��ʲ��Τ褦�ˤ��ޤ���

DELETE FROM films;
SELECT * FROM films;

 code | title | did | date_prod | kind | len
------+-------+-----+-----------+------+-----
(0 rows)

�ߴ���

SQL92

SQL92 �Ǥϡ����֤ˤ�� DELETE ʸ����ǽ�Ǥ���

DELETE FROM table WHERE
    CURRENT OF cursor
    

�����ǡ�cursor�ϥ����ץ�ѤΥ�������μ��̻ҤǤ��� PostgreSQL �����ü�����������ɤ߼�����ѤǤ���